For Excel 2007, "Smart recalculation limits - The dependency limits that
enable smart recalculation rather than full calculation are now limited only
by available memory rather than 8,000 cells dependent on a single area and
64,000 areas having dependencies."

Does Excel 2003 use full calculation? which is limited by 8,000 cells
dependent on a single area and 64,000 areas having dependencies. I am using
Excel 2003, and get a worksheet with a table 10 columns x 5000 rows, which
include 50,000 cells for formula and take me more than 13 mins to do all the
calculation. Is the performance on calculation slow because of reaching the
limitation 8,000 cells?

What does 8,000 cells mean? Does it mean if the maximum cells for formula on
each worksheet? If I get a worksheet with a lot of formula filling 50,000
cells, which exceeds the limitation 8,000 cells, then it will become
unreasonablely slow.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Hi Eric

What is the formula?
What are you trying to achieve?
Can you give an example of the contents of your cells, and the formulae that
you are using in these 50,000 cells.

--

Regards
Roger Govier

"Eric" wrote in message
...
For Excel 2007, "Smart recalculation limits - The dependency limits that
enable smart recalculation rather than full calculation are now limited
only
by available memory rather than 8,000 cells dependent on a single area and
64,000 areas having dependencies."

Does Excel 2003 use full calculation? which is limited by 8,000 cells
dependent on a single area and 64,000 areas having dependencies. I am
using
Excel 2003, and get a worksheet with a table 10 columns x 5000 rows, which
include 50,000 cells for formula and take me more than 13 mins to do all
the
calculation. Is the performance on calculation slow because of reaching
the
limitation 8,000 cells?

What does 8,000 cells mean? Does it mean if the maximum cells for formula
on
each worksheet? If I get a worksheet with a lot of formula filling 50,000
cells, which exceeds the limitation 8,000 cells, then it will become
unreasonablely slow.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric