microsoft excel does not calculate - Automatic calculation is enab

G

Guest

In large workbooks (> 10MB) I found that often Excel does not calculate. I
have to enter the cursor in the cell (or the formula bar) and press enter, so
that the formula is recalculated.
However, my calculation is set on automatic (Tools/Options/Calculate etc.).

Does somebody know why this happens and has an answer?
 
K

Ken Wright

Try the last option on this page and see if it is likely to be your issue:-

http://www.decisionmodels.com/calcsecretsf.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatic calculation 3
Formula Calculation Glitch? 3
Automatic calculation is not working 4
Why does 'calculate' show in the status bar, even after i hit F9? 1
Formulas not calculating - Calculation is on Automatic & I pressed 2
"Automatic Calculation" option intermittent 2
Excel 2003 worksheet doesn't auto calculate 4
excel cells changing to "#VALUE!" whenever another file is opened 8

Top