The number of allowable sheet is limited only by available memory.
Practically however the limit is reached a lot earlier than that. Even if all
of the sheets are the same it is too difficult and too risky a venture to try
to maintain more than a hand full of sheets.

Generally speaking your spreadsheets will be more efficient and maintainable
if you keep all of your source data in one group of sheets. Do all of your
big ugly calculations to the source data in another group of sheets and then
have a few sheets for a user interface and reporting. By changing some
parameters in the user interface and report sheets you can display an endless
variety of information to the user.

In general my biggest projects at this point will have at most about 25
sheets.
--
HTH...

Jim Thomlinson


"ranswrt" wrote:

How many worksheets can be created in a workbook? And does it slow things
down if there are too many?
Thanks