Automatically refresh pivot table when file is opened in Excel 2007
|
Also learn how to automatically refresh pivot table when file is opened in Excel 2003/XP/2000/97. Question: In Excel 2007, how do I get a pivot table to automatically refresh when the Excel spreadsheet is opened? Answer: Right-click on the pivot table and then select "PivotTable Options" from the popup menu.
|
When the PivotTable Options window appears, select the Data tab and check the checkbox called "Refresh data when opening the file". Click on the OK button.
|
Suggested Reading
Home | About Us | Our Services | Software | Excel Templates | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
