Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent recalculation when opening earlier versions
Hi,
Is it possible to prevent recalculation when a workbook, saved in an earlier version, is opened. In this case the recalculation causes problem with formulas in the model. Thank in advance for answers. /Mats -- ESI Update |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent recalculation when opening earlier versions
You might try creating this dword registry entry:
FullCalcOnLoadOldFile with a value of 0 under: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options You didn't mention your Excel version, which posters always should. This is for 11 (2003) but will also work for 10 (2002) if you substitute 10 for 11 in the path. I don't know about earlier versions. -- Jim "Mats Nilsson" wrote in message ... | Hi, | Is it possible to prevent recalculation when a workbook, saved in an earlier | version, is opened. | In this case the recalculation causes problem with formulas in the model. | Thank in advance for answers. | /Mats | | | -- | ESI Update |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compatibility with earlier versions | Excel Discussion (Misc queries) | |||
2003 compatibility with earlier versions | Excel Worksheet Functions | |||
2003 compatibility with earlier versions | Setting up and Configuration of Excel | |||
2003 compatibility with earlier versions | Excel Discussion (Misc queries) | |||
2 versions of XL, how to default to earlier one when opening files | Excel Discussion (Misc queries) |