Disable Multi-Select and Select All Options in Excel 2007 Pivot Table
Is there a way, in Excel 2007, to disable the multi-select and select all options in a pivot table filter? Doesn't matter if it requires VBA code or not.
The pivot tables in question are using MAX calculations, so if the user selects more than one item in the pivot filter, the results will not come back correctly. I do not expect that the users will follow instructions and will attempt to use the multi-select/select all options.