Excel Sheets

[Danny Sanders]

Is the number of sheets one is able to add to an Excel 2003 document
limited?

User wants to create a document with upwards of 400 sheets. Each sheet would
have about 10 rows, each row would have at least 1 calculation.

Is this feasible under Excel 2003?
TIA

DDS

 

[Norman Harker]

Hi Danny:

The maximum number of sheets in a workbook is limited by available
memory.

By default the number of sheets in a new workbook is 3 but this may be
altered by using:

Tools > Options > General
Change to a maximum of 255

However, there is nothing to stop you adding more sheets.

Generally, you'll find things get very slow as you increase the number
of sheets and you might be better advised using more workbooks.




--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Don Guillett]

No, only by memory but that seems like "not the best way" Why 400 sheets?