Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan.
 
Posts: n/a
Default Calculation set as Manual

Hi,

I'm using Excel 2002 SP3 and the calulation option is set as Manual. When I
go and change it to Automatic (which is the way I want it) it works fine
until I close and reopen Excel where upon it sets itself back to Manual.
How can I set it to save to Automatic?

I have, by the way, removed and reinstalled Office, but still the same issue.

Thanks for your time.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas
 
Posts: n/a
Default Calculation set as Manual

Make sure your personal.xls or any other workbook which opens when Excel
opens has its setting to Automatic. The setting is determined by the first
workbook opened, hidden or not.

"Dan." wrote in message
...
Hi,

I'm using Excel 2002 SP3 and the calulation option is set as Manual. When

I
go and change it to Automatic (which is the way I want it) it works fine
until I close and reopen Excel where upon it sets itself back to Manual.
How can I set it to save to Automatic?

I have, by the way, removed and reinstalled Office, but still the same

issue.

Thanks for your time.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
default manual calculation instead of auto in options excel 2003 Lost in Excel Excel Discussion (Misc queries) 1 October 9th 05 06:55 PM
Automatic calculation reverting to manual depending upon who opens Pablito Excel Discussion (Misc queries) 1 August 11th 05 02:54 AM
My Calculation Mode Changed to Manual Somehow?!? Jeb Excel Discussion (Misc queries) 2 August 4th 05 03:40 PM
Manual calculation does not work Hmmmm Excel Discussion (Misc queries) 3 February 17th 05 08:07 AM
"Manual calculation" takes less time. Why? Kjetil Excel Discussion (Misc queries) 1 January 7th 05 12:28 AM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"