How to suppress auto-calculation when opening an older version fil
 

If one opens an Excel file in version XP that was saved using a previous
version, Excel will recalculate all cells.

Is there a way to suppress this or turn it off?
David

How to suppress auto-calculation when opening an older version fil
 

All of mine are set to auto calculate but, as I recall, excel will
automatically take the calculation mode of the FIRST workbook opened.

--
Don Guillett
SalesAid Software

"David" wrote in message
...
If one opens an Excel file in version XP that was saved using a previous
version, Excel will recalculate all cells.

Is there a way to suppress this or turn it off?
David

How to suppress auto-calculation when opening an older version fil
 

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

David wrote:

If one opens an Excel file in version XP that was saved using a previous
version, Excel will recalculate all cells.

Is there a way to suppress this or turn it off?
David

--

Dave Peterson

How to suppress auto-calculation when opening an older version
 

Thank you. I figured there was a Registry tweak even if there were no
"Options" directly configurable by the user.
David

"Dave Peterson" wrote:

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

David wrote:

If one opens an Excel file in version XP that was saved using a previous
version, Excel will recalculate all cells.

Is there a way to suppress this or turn it off?
David

--

Dave Peterson