View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
alberto alberto is offline
external usenet poster
 
Posts: 17
Default How many total worksheets can be added to a workbook?

I will check which version we have on Monday, and how much RAM (I assume) in
the computer; if you want to wait until I get that info, great. If you have
any general guidelines I can use, that would be helpful also.

Thanks

"Jim Thomlinson" wrote:

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?