Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing Reverse Compatibility and Compatibility in General | Excel Discussion (Misc queries) | |||
Excel 2007 backwards compatibility - nesting functions | Excel Worksheet Functions | |||
backwards compatibility for Excel 2007 | Excel Discussion (Misc queries) | |||
Excel is Backwards! | Setting up and Configuration of Excel | |||
Excel 2002 compatibility with earlier versions | Excel Discussion (Misc queries) |