Applescript+Excel+Pivot Table
July 12, 2007 8:57 AM Subscribe
Applescript + Excel . How to suppress subtotals for a field in a pivot table?
Given a generic pivot table with row fields A, B and C and data field D, I want to be able to hide the subtotals in the row fields (equivalent to double-clicking the header and selecting "None").
According to Microsoft's reference guide, there is no option for "None." However, I can't even get one of the listed options to work. The example given on page 240 of the reference guide generates an error message. The following command does absolutely nothing:
Google seems to think that nobody has ever wanted to do such a thing.
Given a generic pivot table with row fields A, B and C and data field D, I want to be able to hide the subtotals in the row fields (equivalent to double-clicking the header and selecting "None").
According to Microsoft's reference guide, there is no option for "None." However, I can't even get one of the listed options to work. The example given on page 240 of the reference guide generates an error message. The following command does absolutely nothing:
set subtotals pivot field "A" of pivot table 1 of active sheet subtotal index average subtotalGoogle seems to think that nobody has ever wanted to do such a thing.
I can't help, but I'm sure someone on Mr Excel would be able to - just in case you haven't come across this resource already.
posted by paduasoy at 2:43 AM on July 15, 2007
posted by paduasoy at 2:43 AM on July 15, 2007
This thread is closed to new comments.
posted by cdavis at 9:14 AM on July 12, 2007