Calculate appears in status bar

[Guest]

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

 

[Chip Pearson]

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

 

[Guest]

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

 

[Charles Williams]

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

 

[Guest]

Thanks. That worked.

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

 

[Guest]

Do you know if that limit is per sheet or for the entire workbook?
If I were to split my biger sheets in a few worksheets, should that solve
the problem?
Thanks. Neda

 

[Charles Williams]

These are the latest Microsoft words describing how these limits are changed
in Excel 12 (from David Gainer's Excel12 Blog).

It is possible that you can avoid one or more of these limits by splitting
large worksheets into multiple smaller worksheets. I have not tried it so I
dont know.

The number of cells that may depend on a single area before Excel must do
full calculations instead of partial calculations (because it can no longer
track the dependencies required to do partial calculations)
Old Limit: 8k
New Limit: Limited by available memory

The number of different areas in a sheet that may have dependencies before
Excel must do full calculations instead of partial calculations (because it
can no longer track the dependencies required to do partial calculations)
Old Limit: 64k
New Limit: Limited by available memory

 

[Guest]

Thanks. I am still struggling to solve that issue in Excel 2003. What really
puzzled me is that I have much larger files with tons of formulas and I never
hit this issue before. I split the most formula heavy sheets, but it didn't
seem to help. I am really at a loss. Excel 2007 seems to deal with that
problem but until then...