Status Bar Shows "CALCULATE"

K

KC Excel Qns

Heard enough of all possible reasons why status bar shows
"CALCULATE".

Without closing and relaunching Excel, is there a way to get rid of the
"CALCULATE" word.

Rgds,
 
L

lesliebantleman

Sounds like the calculation mode is in manual! Press F9 to calculate
now and stay in manual mode. Or go through Tools > Options >
Calculation (tab) and select the automatic option.

Regards,
Leslie Bantleman
 
L

lesliebantleman

Hi David,

Sounds like the calculation mode is in manual! Press F9 to calculate
now and stay in manual mode. Or go through Tools > Options >
Calculation (tab) and select the automatic option.

Regards,

Les
 
K

KC Excel Qns

Oops... should have been more elaborative.

My file being typically 11 MB, I probably have hit the 65535 dependency
limit.

Rgds,
 

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

"Calculate" appears in staus bar 2
Count dates until complete or Cancel 5
Copy data from the Status Bar 3
Workbook causes calculation errors 2
Excel 2003 workbook not updating values 1
Strange Behaviour! Excel wont calculate COUNTIF?? why 3
Status Bar shows "Calculate", but calculation is set to Automatic 1
what does "calculate" mean in status bar? 2

Top