asked on

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

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

ASKER CERTIFIED SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tomar31

try apply service pack1

RDAdams

When using an image via ghost or similar be sure to make the setting in Office on the master prior to running sysprep.

WillHudson

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?

mutec1

ASKER

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

WilfredoPerez

all you have to do is go under view, and restore the defaults, amke sure you have administrator privs to the machine

Member_2_933725

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

mutec1

ASKER

Thanks