Thread: How many total worksheets can be added to a workbook?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default How many total worksheets can be added to a workbook?
The limit is not on the number of sheets, but on the memory XL can access. XL
can not use you entire memory pool. The amount of memory XL can use depends
on the version of XL... If you want more info just reply...
--
HTH...

Jim Thomlinson


"Alberto" wrote:

We seemed to have reached the limit on the number of worksheets in a workbook
at 42 sheets (tabs at the bottom). Is there a way to increase this limit?
Reply With QuoteReply With Quote