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

You can have as many as your computer resources (primarily memory)
allow. If you have a relatively recent computer, that's a lot -
thousands at least.

Usually it's not the number of worksheets that slows things down as much
as the total number of formulae (especially references and lookups). The
size of the workbook is often a good proxy for that - once your workbook
starts getting north of 20MB or so, you'll probably see a slowdown.


In article ,
ranswrt wrote:

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

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

Thanks

"JE McGimpsey" wrote:

You can have as many as your computer resources (primarily memory)
allow. If you have a relatively recent computer, that's a lot -
thousands at least.

Usually it's not the number of worksheets that slows things down as much
as the total number of formulae (especially references and lookups). The
size of the workbook is often a good proxy for that - once your workbook
starts getting north of 20MB or so, you'll probably see a slowdown.


In article ,
ranswrt wrote:

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