XL 2000 'calculate' won't go away

J

Jasone L

Ready Calculate
won't go away

The spreadsheet is large and has many complex formulas, but
no custom functions. I've tried shift-F9, save & re-open,
and other workstations. All updates installed....wtf?

any help appreciated.
 
J

Jan Karel Pieterse

Hi Jasone,
Ready Calculate
won't go away

The spreadsheet is large and has many complex formulas, but
no custom functions. I've tried shift-F9, save & re-open,
and other workstations. All updates installed....wtf?
Click to expand...

When you reach a certain amount of formula references Excel keeps
showing the calculate message. See Charles Williams' site
www.decisionmodels.com for more information about Excels calculation
engine.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 

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

Difference between F9 and Shift+F9 7
F9, Shift+F9, Ctrl+Alt+F9 etc 3
ActiveSheet.Calculate not calculating 3
Calculation in Excel 2000 hangs processor. 2
Spreadsheet won't calculate 3
Formulas won't calculate 3
Calculate at bottom of screen does not go away 1
Workbook causes calculation errors 2

Top