» Refreshing the Data in PivotTable Report while Opening a Workbook in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To refresh the data in PivotTable report while opening a workbook:1. Select a cell in the PivotTable report.
2. Right click the cell and select Table Options -> Data tab -> check Refresh data when opening the file - > click OK.
Book Store:
Recommended Books:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Learn MS Excel 2002 VBA/XML Programming
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- The Ernst & Young Business Plan Guide
No comments have been submitted.
