How to stop Automatic calculations?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!! :)
 
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).
 
Back
Top