calculate message in status bar

N

neda5

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
 
J

JMB

The only time I've seen Calculate show up in the message bar is when
calculation is set to manual (the message prompts you that changes have been
made and the user needs to re-calculate).
 
M

Manoj

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.
 
N

neda5

Thanks Guys,
but that didn't help. I work in manual mode, b/c my spread sheets are large
and it takes a while to calculate, but the problem is that even when I hit F9
it calculates up to 88% and then reverts to showing calculate again.
Thanks. Neda
 

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

Missing items in the menu bar 1
How to make scroll bar permanently visible, Word 365 0
Populate a table based on check box status 2
Calculate the median value before a specified list 0
what does "calculate" mean in status bar? 2
Status Tool Bar and "Calculate" 4
Excel Issue with "Average" showing in Status Bar 2
Calculate appears in status bar 7

Top