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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
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) |