Pivot tables created in Excel 2007 will not work in Excel 2003
Excel has a very uncomfortable bug – if you create a Pivot table in Excel 2007, then it will be “readonly” in earlier versions. I.e you can’t apply any new filters or re-arrange data fields. The only picture you see is like a static snapshot of the moment when it was last saved in Excel 2007. Even saving in 2003 compatibility mode will not help. Somehow the creation algorithm of a Pivot table is different in Excel 2007.
What to do when you need to have a Pivot table which can be used for Excel 2003 and 2007 users at the same time? The only solution I know is to first create a Pivot table in Excel 2003. After that you can edit the Pivot in 2007, save modifications and it still works in both versions of Excel. So it is useful to have an older version of Excel available besides 2007.
