Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: PivotTable not displaying properly as webpage

    I'm saving a PivotTable to be viewed on our Intranet site. Yesterday it was working fine with the drop-downs to select a date to view, etc.

    I re-saved it today and now it displays as more of a spreadsheet rather than a pivot table. The drop-downs are gone, so you can no longer select a date.

    When I saved it as a webpage, I selected "Add Interactivity" and Republish Sheet and clicked the "Publish" button. It gave me the option of spreadsheet or pivot table functionality. I chose pivot table functionality.

    I really need the pivottable functionality of this.


  2. #2
    Join Date
    Oct 2003
    Note from the Help section:

    "You cannot open and modify interactive Web pages in Excel, so it's a good idea to save a copy of the original workbook from which you publish in case you want to make changes in Excel and republish."
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2004
    There may be a misunderstanding. I'm not trying to open the webpage pivotTable in Excel.

    The original pivottable is in Excel. I saved it as a webpage.

    It appears correct in Excel, but the webpage lacks the dropdowns, etc.

    I hope this clarifies things.

Posting Permissions

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