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.

Blogger news