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

Posted on 2004-03-24
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,

Question by:mutec1
LVL 81

Accepted Solution

byundt earned 125 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:



Expert Comment

ID: 10669975
try apply service pack1
LVL 17

Expert Comment

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.
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

LVL 13

Expert Comment

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?

Author Comment

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


Expert Comment

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

Expert Comment

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.


Author Comment

ID: 10847609

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
I need a software suggestion 4 75
Microsoft  Partnership 1 80
Free Alternative to JIRA 4 103
cloning computer 13 83
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Let’s list some of the technologies that enable smooth teleworking. 
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

773 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