Excel - Memory Limitations?

[SBaker]

Excel 2000
Latest Service Pack

Does anyone have a good estimate for the memory needs for a workbook with
the following specifications?

Worksheets - 80+
Charts - 25+

I have found the following specifications documented as the limits for
Excel:
Sheets in a workbook Limited by available memory (default is 3
sheets)

I want to ensure that we have enough memory to cover the needs of the
workbook.

Thanks,

Scott

 

[Nick Hodge]

Scott

Excel only has a fixed 'pool' of memory for operating, irrespective of
system memory. Some versions gobbled it using certain objects in abundance,
eg. charts.

A great site for detailed explanation is

http://www.decisionmodels.com/memlimitsc.htm