Problem: Excel defaults to 'Manual' Calculation in Tools/Options

[NWildblood]

This may be a bug?? A few of us are finding that Excel is defaulting to 'Manual' Calculation rather than 'Automatic', even after we have changed the Tools/Options/Calculation preference to 'Automatic' during the same session... it happens on pre-existing and new spreadsheets, but not all the time...
...sounds like a bug to me; I have passed it to our support people in India - meanwhile has anyone else seen similar problems ? Any info gratefully received, thanks.

"Nothing upsets a vulture more than a glass eye...

 

[xlbo]

It only takes opening 1 workbook with manual calc set to make the application setting change to manual calc. This is because the calculation mode is a property of the application rather than the workbook...

Bottom line - If you set calc to auto and then open a manual calc workbook, the calc settings will be set to manual...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[NWildblood]

Thanks xlbo, but this has only just recently happened affecting four or five (not all) users yet the workbooks we have opened are various ones unique to each user, all traditionally set to auto calc, and in established use, with no previously-experienced problems... I might also add: no-one would set any workbook to manual calc; there's no need - so why would the opening default change ? Sorry if I'm being dense and haven't understood - I appreciate your info.

"Nothing upsets a vulture more than a glass eye...

 

[xlbo]

try checking the workbooks - one or some of them will be set to manual calc. It may be a file that was received from an extrnal source that set the calc to manual in the 1st place. If a user then saves a different file, whilst the calc state is manual, that file will be saved with manual calc state. When that file is re-opened, it will set the manual calc state for the app and so the circle continues...



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[NWildblood]

xlbo

Ah yes, thanks, it could be one or more of our client's recent workbooks at fault, will investigate.
(I am debating the virtue of this workbook to application relationship right now...)

Many thanks for your prompt replies
Regards
OoS

"No-one got everything done by Friday except Robinson Crusoe...

 

[dgillz]

Do you have any excel addins installed? I know of a couple that force manual calculation.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[NWildblood]

dgillz
Thanks, no we just have a 'vanilla' package, but our clients may of course have a number of mods... appreciate the response.


"No-one got everything done by Friday except Robinson Crusoe...

 

[NWildblood]

dgillz
"I know of a couple that force manual calculation."
sorry - what are they by the way, out of interest ?
Thanks again.

"No-one got everything done by Friday except Robinson Crusoe...

 

[xlbo]

investigating the virtue of it? that's just the way it works I'm afraid

Calculation stacks are recorded at application level so calculation must be an application level property.

Individual workbooks need to have that property set within them otherwise when you open a manual calc workbook, it would automatically calculate - which would negate the point of making it a manual calc workbook...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[NWildblood]

Geoff, ok, thanks.

"No-one got everything done by Friday except Robinson Crusoe...