Auto Calc Problems

coeswg

New Member
Joined
Sep 20, 2006
Messages
1
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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
 

Forum statistics

Threads
1,136,878
Messages
5,678,312
Members
419,754
Latest member
LordEddard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top