PC Review


Reply
Thread Tools Rate Thread

Auto Calculate Keeps Resetting to Manual

 
 
Shirley
Guest
Posts: n/a
 
      14th Apr 2010
Cannot get this to stay at automatic. Any thoughts why?

New workbook, nothing complicated (b2/b3). I save the document, reopen and
set to recalculate. The next day when I open, it's back to manual.

I hate when things weird out.


 
Reply With Quote
 
 
 
 
Fred Smith
Guest
Posts: n/a
 
      14th Apr 2010
The recalculation setting comes from the first workbook you open. Do you
have another workbook that has its setting to manual?

Regards,
Fred

"Shirley" <(E-Mail Removed)> wrote in message
news:6FE5E667-2461-4E2D-9BE7-(E-Mail Removed)...
> Cannot get this to stay at automatic. Any thoughts why?
>
> New workbook, nothing complicated (b2/b3). I save the document, reopen
> and
> set to recalculate. The next day when I open, it's back to manual.
>
> I hate when things weird out.
>
>


 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      14th Apr 2010
As a follow on to Fred's answer - do you have workbooks in the XLSTART
folder?
These will open every time you start Excel and could be hidden
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Shirley" <(E-Mail Removed)> wrote in message
news:6FE5E667-2461-4E2D-9BE7-(E-Mail Removed)...
> Cannot get this to stay at automatic. Any thoughts why?
>
> New workbook, nothing complicated (b2/b3). I save the document, reopen
> and
> set to recalculate. The next day when I open, it's back to manual.
>
> I hate when things weird out.
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why did auto calculate suddenly change to manual calcu... pfelton Microsoft Excel Misc 4 9th Mar 2010 03:57 PM
Auto Calculate switches to manual lawatters Microsoft Excel Crashes 0 3rd Feb 2009 02:56 PM
AUTO/MANUAL Calculate in Excel when opening *.slk files Jim Microsoft Excel Programming 0 8th Nov 2007 07:56 PM
How do you make the auto calculate setting stay on manual permanently? anasttin Microsoft Excel Programming 2 9th Mar 2006 12:03 AM
Service resetting to manual =?Utf-8?B?U2hheW5lIEZyeWU=?= Microsoft Windows 2000 Advanced Server 0 10th May 2005 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:00 PM.