Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop Automatic calculations?
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!! :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop Automatic calculations?
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/groups?thre...GP11.phx .gbl His message dealt with xl2k (version 9.0 in in the registry key). xl2007 is version 12. 1ThngOrAnthr wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop Automatic calculations?
Thank you! That fixed it (so far).
For future references, this is how I solved the problem with Excel 2007 StartRun Type "Regedit" (no quotes) Find the file HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop calculations? | Excel Discussion (Misc queries) | |||
Automatic Calculations | Excel Worksheet Functions | |||
automatic calculations | Excel Worksheet Functions | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
Automatic and manual calculations | Excel Discussion (Misc queries) |