View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
neda5
 
Posts: n/a
Default Calculate appears in status bar

Thanks. That worked.

"Charles Williams" wrote:

The message does not go away until you close and reopen Excel.

see http://www.decisionmodels.com/calcsecretsf.htm

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"neda5" wrote in message
...
Thanks.
However, I deleted most of the formulas to make sure that I don't have
more
than the limit of cell dependencies and it still gives me that message.
Any other ideas?
Thanks

"Chip Pearson" wrote:

You will get this if there are more than 64K cell dependencies.
The workbook does calculate properly, but the message appears in
the status bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"neda5" wrote in message
...
Hi,
I have a rather large spreadsheet (apx 30MB) and all of a
sudden the
calculate message kept reapearing in the status bar at the
bottom. I am in
manual mode so I hit F9 and it calculates to a certain level
and then goes
back to show calculate. I don't show having a circular and my
itirations is
off and I don't show any links to other documents. Since the
file is rather
large and I have a bunch of formulas linking all over the place
I tried to
erase my most formula heavy sheets and see what happens, but
Calculate
remains.
I have read all the posts on the issue and nothing seems to
help me.
Any ideas????
Thanks a bunch.
Neda