How many total worksheets can be added to a workbook?

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

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?
 
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...
 
I have just written 2 lines of code to see just how many sheets can be added
to an Excel 2003 workbook and it is currently over 2,000. Maybe your
workbook is protected and preventing you from adding further sheets.
 
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
 

Ask a Question

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.

Ask a Question

Similar Threads

How many worksheets can you have in one workbook? 9
Many worksheets in a workbook 3
Excel Move or Copy Stopped Working? 0
Manage a high number of worksheets in one workbook (Excel 2007) 4
How can I get excel to accept larger workbooks 2
Running Sum of cell in many spreadsheets 1
sheets gone from workbook 2
converting 2002 workbooks to 2007 1

Back
Top