Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel loses "Automatic calculation" option

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 18-10-2008
Member
 
Join Date: Aug 2006
Posts: 139
Excel loses "Automatic calculation" option

Normally if I am opening any Excel file and enter some data then I notice that the option to recalculate all formulas automatically clears out. Where I am going actually is Excel Options >> Formulas >> Calculation Options >> Workbook Calculation >> Automatic. I am using windows xp with service pack 3 and having Excel 2007 with SP1 MSO. Any ideas?

Reply With Quote
  #2  
Old 19-10-2008
Member
 
Join Date: Jan 2006
Posts: 6,913
Excel recalculation settings are not stored as application level settings but are stored in workbooks and this setting is taken from the First workbook it opens. I guess that you are not using a Personal.xls file, so the first file you open might be varying from Excel session to Excel session. If you open this particular workbook first, then Excel takes its recalculation setting from this workbook and it was saved with recalculation set to manual.
Reply With Quote
  #3  
Old 09-12-2008
Member
 
Join Date: Dec 2008
Posts: 1
Re: Excel loses "Automatic calculation" option

Here's the Microsoft page that explains how Excel operates with respect to Manual and Automatic Calculation. http://support.microsoft.com/kb/214395

Hope this helps.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel loses "Automatic calculation" option"
Thread Thread Starter Forum Replies Last Post
Disable "Save" and "Save As" functionality in all windows versions of excel bhithy Windows Software 3 04-03-2012 12:53 AM
<input type="button" value="Enregistrer" onclick="location.href=../asp/PRaces.asp"> Luz Software Development 6 18-05-2010 12:27 AM
Open IME" & "Reconversion" option on context menu, How do I remove RHPT Vista Help 7 27-01-2010 12:11 AM
Excel 2003 calculation automatic loss option CitricAcid Software Development 4 08-04-2009 10:09 AM
Project Web Access via IE7: "Export Grid to Excel" cause VBSCRIPT (error) message: "The activeX control on which this feature depends could not be created" Theo-Dore Microsoft Project 2 17-01-2007 08:47 PM


All times are GMT +5.5. The time now is 06:10 PM.