Backwards Compatibility with Excel 2002
 

I have a massive Excel 2002 workbook (17 sheets, ~250,000 cells with
formulas, 12.6MB) for work, and we now use Excel 2007. When I open the file
in Compatibility Mode 97-2003 in Excel 2007, the cells will not recalculate
when their linked cells' values throughout the workbook are changed. The
calculate mode is set to Automatic. Shift+F9 does nothing. Cells will only
recalculate if I click on each individual cell's formula and hit Enter or if
I Save As (just Save will not work). After Saving As, the cells will again
not calculate until I Save As again. i.e. Save As is working like Shift+F9.
I used the Convert button to update it to 2007 with the same results. At
home, the 2002 file opened in 2002 calculates normally as cells change. Any
idea why this is happening? Any fixes, even if they're round-about?

Backwards Compatibility with Excel 2002
 

You may want to try selecting all the worksheets
Selecting all the cells
Replace
what: =
with: =
replace all

ungroup the sheets

And see if that woke up excel.

elfregono wrote:

I have a massive Excel 2002 workbook (17 sheets, ~250,000 cells with
formulas, 12.6MB) for work, and we now use Excel 2007. When I open the file
in Compatibility Mode 97-2003 in Excel 2007, the cells will not recalculate
when their linked cells' values throughout the workbook are changed. The
calculate mode is set to Automatic. Shift+F9 does nothing. Cells will only
recalculate if I click on each individual cell's formula and hit Enter or if
I Save As (just Save will not work). After Saving As, the cells will again
not calculate until I Save As again. i.e. Save As is working like Shift+F9.
I used the Convert button to update it to 2007 with the same results. At
home, the 2002 file opened in 2002 calculates normally as cells change. Any
idea why this is happening? Any fixes, even if they're round-about?

--

Dave Peterson

Backwards Compatibility with Excel 2002
 

Is Ctrl Alt F9 working ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"elfregono" wrote in message ...
I have a massive Excel 2002 workbook (17 sheets, ~250,000 cells with
formulas, 12.6MB) for work, and we now use Excel 2007. When I open the file
in Compatibility Mode 97-2003 in Excel 2007, the cells will not recalculate
when their linked cells' values throughout the workbook are changed. The
calculate mode is set to Automatic. Shift+F9 does nothing. Cells will only
recalculate if I click on each individual cell's formula and hit Enter or if
I Save As (just Save will not work). After Saving As, the cells will again
not calculate until I Save As again. i.e. Save As is working like Shift+F9.
I used the Convert button to update it to 2007 with the same results. At
home, the 2002 file opened in 2002 calculates normally as cells change. Any
idea why this is happening? Any fixes, even if they're round-about?