S
SMD
Hi,
I am trying to find out how-if possible, to tell Applescript to set the subtotals in a pivot table report to none. I have done numerous searches on the web and can find no information on this. I have read the Excel 2004 Applescript reference, but this does not make any reference to this.
I have an Applescript that creates a pivot table from data exported from filemaker. It produces the table fine, but shows subtotals. I know you can double click the relevant pivot field & select none for subtotals, but this is laborious when you have 15+ such fields and you are preparing the report for users with limited knowledge of excel. If anyone could help with this or suggest where I could find additional info, I would be very grateful.
I am trying to find out how-if possible, to tell Applescript to set the subtotals in a pivot table report to none. I have done numerous searches on the web and can find no information on this. I have read the Excel 2004 Applescript reference, but this does not make any reference to this.
I have an Applescript that creates a pivot table from data exported from filemaker. It produces the table fine, but shows subtotals. I know you can double click the relevant pivot field & select none for subtotals, but this is laborious when you have 15+ such fields and you are preparing the report for users with limited knowledge of excel. If anyone could help with this or suggest where I could find additional info, I would be very grateful.