Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Question 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.


  2. #2
    Join Date
    Sep 2008
    London, UK
    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.
    Attached Thumbnails Attached Thumbnails Pivot Picture.PNG  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts