by Allen Wyatt
(last updated October 21, 2017)
Susan has a workbook that was originally created in Excel 2003 containing several PivotTables. She loaded the workbook in Excel 2007 and added additional PivotTables, then saved it in compatibility mode so it could still be used in Excel 2003. However, if she doesn't open the workbook in Excel 2007 the PivotTables will not update either manually or automatically. It works fine if she opens it in Excel 2007, but not in Excel 2003. Susan wonders if this is normal behavior.
Apparently it is. From the information we can gather, it appears that if a PivotTable is created in Excel 2007, even if the workbook is saved in compatibility mode it will not work properly in Excel 2003. (You won't be able to reliably edit or update the PivotTable in Excel 2003.) The only solution is to recreate the PivotTables in Excel 2003.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6950) applies to Microsoft Excel 2003.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Need to reduce the size of your workbooks that contain PivotTables? Here's something you can try to minimize the ...Discover More
If you modify the data on which a PivotTable is based, you'll need to refresh the table so it reflects the modified data. ...Discover More
If you are using a data set that includes a number of zero values, you may not want those values to appear in a ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.