Applescript+Excel+Pivot Table

July 12, 2007 8:57 AM

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:

set subtotals pivot field "A" of pivot table 1 of active sheet subtotal index average subtotal

Google seems to think that nobody has ever wanted to do such a thing.

posted by cdavis to computers & internet (2 comments total)

Oh, I'm using Excel 2004 and Applescript 1.10.7 (OS X 10.4.10).
posted by cdavis at 9:14 AM on July 12, 2007

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