Discussion Locked

Excel 2000 Auto calculation issues

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When my user creates a quote and applies auto calculation, all is well.

When said user goes back into the quote to change data, Excel goes to manual calculation, meaning it flips from auto calculation. The user is not doing anything to change that.

How can we get Excel to stay with auto calculation?

Thanks

1 reply

by dreamboat

Wow. I am surprised this question is unanswered. The only resolution I have for you, however, is this rule:

If you have ONE Workbook open that is set to manual calculation, NONE of the currently opened Workbooks will auto-calc. Perhaps your user is constantly using a reference Workbook when she's in the one that needs to auto-calc?

Just a thought.

This discussion is closed to new replies.