Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate message in status bar
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate message in status bar
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). "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate message in status bar
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate message in status bar
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 "Manoj" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate appears in status bar | Excel Discussion (Misc queries) | |||
Urgent- Help ! (Message 'Calculate' Appears) | Excel Discussion (Misc queries) | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) | |||
Calculations And Order In Macros | Excel Discussion (Misc queries) |