Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,022
Excel 2003 calculation automatic loss option

Hello everyone,

I lose a random option on my automatic posts in Excel 2003. I tried to insert a macro in the Open personal.xls but without success, and as I am novice in VBA ...

Someone there had this problem?
Reply With Quote
  #2  
Old 08-04-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Excel 2003 calculation automatic loss option

Can you be a little more explicit? Not obvious to help solve this problem with so little information ...
Reply With Quote
  #3  
Old 08-04-2009
Member
 
Join Date: May 2008
Posts: 3,971
Re: Excel 2003 calculation automatic loss option

Is not the code that you inserted in your procedure that is involved:

To switch to manual calculation

With Application
.Calculation = xlManual

to return to automatic calculation (eg end of treatment)

With Application
.Calculation = xlAutomatic
Reply With Quote
  #4  
Old 08-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,022
Re: Excel 2003 calculation automatic loss option

Hello and thank you for your response!

That's what happens:
In Excel 2003, I validate that the option "Automatic calculation". I open a file xl. I control the method of calculation (tools/options/calculation ...) if the manual mode is activated, I validate the automatic mode. I'm, I close excel, I re-open Excel and then the same file ... and it is in manual calculation mode or "on order" enabled! This occurs regardless of the files but only in Excel 2003.

hoping to have been more clear ...
Reply With Quote
  #5  
Old 08-04-2009
Member
 
Join Date: May 2008
Posts: 3,971
Re: Excel 2003 calculation automatic loss option

In Options >> Calculation: Iteration mode is checked? If so uncheck it.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2003 calculation automatic loss option"
Thread Thread Starter Forum Replies Last Post
Calculation Repeatability & Reproducibility on Microsoft Excel Ella Mentry MS Office Support 2 09-02-2012 06:35 PM
calculation of date, month and year using excel Edgar-Arular Windows Software 4 06-04-2011 04:26 PM
Calculation of business hours in Excel Jayden Windows Software 3 29-07-2009 08:15 AM
2003 excel calculation error titanpro Windows Software 2 20-07-2009 07:01 PM
Excel loses "Automatic calculation" option MarceloQuad MS Office Support 2 09-12-2008 10:33 AM


All times are GMT +5.5. The time now is 04:15 PM.