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.

Thanks.

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

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.