Creating a Pivot Table with existing data in a workbook

[Elliott]

I am trying to open an existing multi page workbook and create a pivot table for each sheet using sas.  I am not having much luck with the ods tagsets.tableeditor examples I have found.  They all want to produce a button that then opens excel.  That does not work for me.  I am already using ods to create the output in an excel sheet and emailing it to myself with sas.  I want to add the pivot tables so I don't have to manually create them.  Is there any information available that will help me achieve this?

Thanks,

[Cynthia_sas]

Hi:
TAGSETS.TABLEEDITOR works by using JavaScript to take the originally produced HTML table and then produce an Excel workbook/sheets. So, I am not sure whether you can do what you want, directly with the destination. This may be a question for Tech Support.

cynthia