This generally happens when Tools- options - calculation (tab) -
calcuation mode is set to manual. Change this to Automatic.

Alternatively hit the F9 key to refresh whenever you need to.


"neda5" wrote:

I can't get the calculate message in the status bar to disappear. I believe
the reason is due to going over the limit of references. Is there a way to
check that and is the 65K limit per worksheet or workbook?
Thanks. Neda