Save changes to a PivotTable list
If you're using Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later, changes that you make to the PivotTable list are retained during the browser session, even when you return to the PivotTable list after viewing other Web pages. However, if you reopen the Web page
To make changes to a PivotTable list and save your changes in a file, open the PivotTable list in a design program such as Microsoft FrontPage or Microsoft Access.
You can also export the PivotTable list to a Microsoft Excel PivotTable report, and then save the Excel report. For more information, see Excel Help.