Excel Calculation

A

Arima53

I click Tools, Options, Calculation and then click the Manual radio button
and turn off the Recalc Before Save. Then I Save the workbook and exit. When
I open the workbook again, the Calculation has gone back to Automatic. I have
only noticed this on my home computer. At work the setting stays on Manual
until I physically click the Automatic button again.

I use Office Professional 2003 but noticed it on my Office Professional 2000
too. What is wrong?
 
N

Nick Hodge

Arima

Excel takes it's calculation setting from the first workbook you open in a
session and applies that to all subsequent books open. Is it possible you
are opening a workbook at home before you open the workbook in question.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
K

Ken Wright

Personal.xls maybe?? Opens up without you seeing it. Possible you have this
at home but not at work.

( Hi Nick :-> )

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
A

Arima53

No. The problem only occurs at home. It is the only workbook I open in the
session.

Arima
 
N

Nick Hodge

Arima

Go to Window unhide and see if it is listed there, if so, Unhide it, reset
the option to Automatic via Tools>Options... and then save the personal.xls
and rehide it via Window>Hide

If it asks to save personal.xls on closing answer yes

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
A

Arima53

The only thing I saw there was something called jwpacke.xls. I didn't unhide
it because I don't know what it is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Problem activating pre-installed MS Office home and Student 0
I figured out the issue thank you. 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Remote stopped working in PowerPoint Presenter View 0
Is it possible to edit colours already saved as part of a custom theme? 0
Automatic Calculation of Spreadsheets 1
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top