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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
 
Upvote 0

Forum statistics

Threads
1,217,331
Messages
6,135,938
Members
449,973
Latest member
jarzack

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
Back
Top