Existing spreadsheet works fine with XL 2004, 2007 (PC) but not 20

[Fred Hoysted]

I have a spreadsheet which I originally developed in Excel 2004. Recently
I've been sharing it between XL 2004 and 2007 (in XP) and it works just fine.
Xl 2008 will eventually open it but it takes 4 or 5 minutes. And then
changing cell values results in the application hanging.

There is no VBA in this spreadsheet
It is not overly large, but there are many, many array calculations.
However, calculation time is less than 1 second in XL 2007.
I've tried saving and opening it in all the available formats
Other spreadsheets work fine

Does anyone have any pointers as to what I might do to trace the problem?

Many thanks,

Fred

 

[JE McGimpsey]

I have a spreadsheet which I originally developed in Excel 2004. Recently
I've been sharing it between XL 2004 and 2007 (in XP) and it works just fine.
Xl 2008 will eventually open it but it takes 4 or 5 minutes. And then
changing cell values results in the application hanging.

There is no VBA in this spreadsheet
It is not overly large, but there are many, many array calculations.
However, calculation time is less than 1 second in XL 2007.
I've tried saving and opening it in all the available formats
Other spreadsheets work fine

Does anyone have any pointers as to what I might do to trace the problem?

No change when you save it as a .xlsx file in XL07?

It sounds like workbook corruption, though I'd have thought that saving
in .xlsx format would help.

One method that sometimes works is to create a new workbook, and, using
CMD-c/CMD-v, copy and paste the contents of your old worksheet(s) to the
new workbook. It's a real PITA if there are a lot of cross-sheet
references, but it can remove deeply embedded corruption.

XL08 will be slower than XL07, but it should recalculate on the same
order of magnitude as XL04.