Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

An excel document with several pivot and lookup tables that previously worked under Office XP and 2003 has stopped working after upgrading to office 2007 (and linked stuff doesn't update any more either).

I originally assumed there's something disabled in 2007 that I need to turn back on, but after having opened it in Excel 2007 it no longer works in previous versions either.

Any idea what I'm missing, what Excel 2007 did and how I fix it?

share|improve this question
What version of Excel is the spreadsheet saved in? 97-2003 (.xls) or 2007 (.xlsx)? – Mark May 5 '10 at 16:30

Take a look at this article written by Microsoft explaining the differences between the Pivot Table formats within Excel. It lists a table of possible outcomes based on the version of your spreadsheet and the version of the Pivot Table within the spreadsheet:

share|improve this answer
that chart indicates it should keep working, but it does not :( The spreadsheets an xls and it "breaks" after simply opening it (in compatibility mode) in 2007 i.e. no changes, no save just exit – user35455 May 6 '10 at 14:25

You must log in to answer this question.