Unanswered: Pivot Table EnableMultiplePageItems in Excel 2003
I have a pivot table in excel 2003 with page fields. However there is no option for the page fields to select multiple items. Does any one know how to enable the EnableMultiplePageItems property in excel 2003.
I've done an extensive search but cant seem to find a solution to this.
Yes, you can double click on the page field button on the spreadsheet and then select the items to hide in the "Hide Items" listbox. See attached screenshot. I don't know a way to do it directly within the dropdown box on the spreadsheet.