Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel calculation tab under tools options does not stay on automatic.

Posted on 2004-03-24
9
Medium Priority
?
324 Views
Last Modified: 2012-06-22
I have a user in my office that asks the following question.

"My laptop was recently re-imaged. Excel is now configured to manualy calculate formulas.  I changed the option under tools/options "calculation tab" to automatic, but the changed setting does not stay for future files.  I tried saving files with the new option and also not saving the file with the new option.  No matter what I do, every time I start a new Excel file it starts up configured to calculate manually. Please advise."


Is there a registry change I could use to force the setting to stay on automatic.


Thanks for your help in advance,

Mutec1
0
Comment
Question by:mutec1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 10669212
Hi mutec1,
Try finding and renaming your toolbar settings file *.xlb to *.old (the * being replaced with your Windows log-in name). This file is normally found in your C:\Documents and Settings\your name\Application Data\Microsoft\Excel directory. Excel will create a new one the next time it launches. For more information on Excel troubleshooting, see:
http://www.cpearson.com/excel/StartupErrors.htm
http://j-walk.com/ss/excel/usertips/tip076.htm

Cheers!

Brad
0
 
LVL 2

Expert Comment

by:tomar31
ID: 10669975
try apply service pack1
0
 
LVL 17

Expert Comment

by:RDAdams
ID: 10671558
When using an image via ghost or similar be sure to make the setting in Office on the master prior to running sysprep.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 13

Expert Comment

by:WillHudson
ID: 10676313
Hmm... tried changing it on my PC, and it wants to save changes to the work book - but on mine it was already on default of automatic...

Whats happens if you or someone else logs into the laptop? Same thing?
0
 

Author Comment

by:mutec1
ID: 10678238
The user is out of the office I'm trying to see when he will be back in.

0
 

Expert Comment

by:WilfredoPerez
ID: 10682277
all you have to do is go under view, and restore the defaults, amke sure you have administrator privs to the machine
0
 
LVL 10

Expert Comment

by:mikeopolo
ID: 10691576
I'd suggest opening the Excel program on the users laptop, change the calculation setting to automatic, then save the workbook as "book1.xlt" (ie as a template) in the microsoft office\office\xlstart folder. This template will be opened automatically each time Excel is started.

Regards
Mike
0
 

Author Comment

by:mutec1
ID: 10847609
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question