Pivot tables created in Excel 2007 will not work in Excel 2003
December 7th, 2009
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? Read more…
