Calculate appears in status bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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
 
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...
 
Back
Top