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

"Charles Williams" wrote:

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