Maximun number of worksheets in a workbook

[Tom LeBold]

What is the maximun number of worksheets that a workbook
can contain?

 

[Jim]

Dependent upon you system, primarily the amount of memory.

 

[Norman Harker]

Hi Tom!

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.