i have a simple question but its baffeling. sometimes my auto calc works and sometimes it doesnt. This happens on the same spreedsheets in different situations. I have already checked the options and rebooting as well as reinstalling excel. I am using excel 2002sp3. does anybody have any idea what i could be doing wrong.thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Calc Problems
- Thread starter coeswg
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Hi, and welcome to the Board!
There's a couple of options I can think of (most likely there are others too).
One is that you have heaps of formulas that cross-reference each other, and evrything grinds to a halt. Another symptom of this is slloooowww performance.
Another is that it depends on which workbooks you opened, in which order. For example, if you first open a workbook that sets calculation to Manual, this is the setting that Excel uses for the rest of that session.
Denis
There's a couple of options I can think of (most likely there are others too).
One is that you have heaps of formulas that cross-reference each other, and evrything grinds to a halt. Another symptom of this is slloooowww performance.
Another is that it depends on which workbooks you opened, in which order. For example, if you first open a workbook that sets calculation to Manual, this is the setting that Excel uses for the rest of that session.
Denis
Upvote
0
Similar threads
- Question
- Question
