Browse » Home
Monday, March 28, 2011
How to Convert Excel 2003 AutoFormat PivotTables to Excel 2007
1. Open Excel 2007.
2. Click 'File,' 'Open.' Double-click the Excel 2003 workbook that contains the PivotTable. The workbook opens in Compatibility Mode.
3. Click the Microsoft Office Button in the upper-left. Click 'Convert.' Click 'OK' to confirm.
4. Click 'Yes' and the newly converted workbook will open and is ready to use.
5. Click 'File,' 'Save' to confirm the new settings.