Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Autocalculation keeps getting reset to manual

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gumbatman - 15 Aug 2007 15:45 GMT
Hello,

Every time I open Excel, the Automatic Calculation is set to manual. I go
into Tools -> Options, click the Calculation tab and set it to Automatic.
However, each time I reopen Excel it gets reset back to manual.

It was working fine and then one I day Excel crashed and it hasn't been the
same since.

If it makes a difference, when I open Excel, it is opening a Personal.xls
file, there are also some add-ins that I have. However, I never put any code
to make it shut the Automatic Calculation off.

Thank you for the help.

-Gumbatman
Jim Rech - 15 Aug 2007 16:45 GMT
Calc mode is set by the first workbook opened, probably Personal.xls in this
case.  I'd guess you last saved it with calc manual.  So try resaving
Personal after setting calc to automatic.

Signature

Jim

| Hello,
|
[quoted text clipped - 12 lines]
|
| -Gumbatman
Gumbatman - 17 Aug 2007 15:07 GMT
Jim,

You were right. It now works correctly!

Thank you for the answer.

-Gumbatman

> Calc mode is set by the first workbook opened, probably Personal.xls in this
> case.  I'd guess you last saved it with calc manual.  So try resaving
[quoted text clipped - 18 lines]
> |
> | -Gumbatman

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.