Hide "Select Multiple Items" in Report Filter

[delecto]

Hi all,

I have a series of PivotTable reports in Excel 2007 and all of my values are set to "Max" not "Sum." (Needs to be "Max" because there are % changes, which aren't additive). Despite warning people not to select multiple items from the report filters, they do it anyways, resulting in inaccurate data. So, I've been looking (for years!) for a way to hide or disable the "Select Multiple Items" option from the Report Filters.

Is this possible? Finger's crossed...

-Jill

 

[jim may]

Maybe here....

http://office.microsoft.com/en-us/a...ivottable-or-pivotchart-view-HP003083504.aspx

 

[delecto]

Thanks Jim - alas, it looks like that applies to Access 2003 but I'm looking for the same feature (or VBA code) in Excel 2007...