If you are using ODS, then you have no choice but to recreate your Excel workbook each time, including pivot tables. Another way to do this would be to export your SAS data to one worksheet in your already existing Excel workbook, maybe using PROC EXPORT, but then manually create your pivot table based on that data in another worksheet. That way, whenever you update the Excel base data worksheet, your pivot table will update as well.
... View more