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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
