Hi

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.

Thanks

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.