Calculate appears in status bar

N

neda5

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
 
C

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
 
N

neda5

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
 
N

neda5

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
 
C

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
 
N

neda5

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

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

Top