How to stop Automatic calculations?

[Guest]

Since I've download the MS Office 2007, I am having the below issue.
Everytime I open an email attachment, view it and then go to close it, I get
the following message:
"Do you want to save changes to "file name"? Excel 2007 recalculates
formulas when opening files last saved by an earlier version of Excel."

I don't want this message everytime I close a document. I've looked in the
Excel options and found how to turn off automatic calculations, but to my
dismay the preference change is document specific. So, once that document is
closed, it doesn't remember that preference.

If anyone knows what I am talking about, please help me out to turn this
thing off! Thanks!!

 

[Dave Peterson]

Jim Rech posted a registry tweak that works with xl2003 and below--I'm not sure
if it works with xl2007.

http://groups.google.com/[email protected]

His message dealt with xl2k (version 9.0 in in the registry key).

xl2007 is version 12.

 

[Guest]

Thank you! That fixed it (so far).

For future references, this is how I solved the problem with Excel 2007

Start>Run
Type "Regedit" (no quotes)

Find the file HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

****note, I have 12.0 written because that is the version that I am
using. If you have a different version, replace 12.0 with the correct version
number.

Right click to create a new DWAROF value. Name it: FullCalcOnLoadOldFile
Leave the value as 0 (zero).