Thread: Worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Worksheets

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?