How many total worksheets can be added to a workbook?

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?
 
J

Jim Thomlinson

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...
 
G

galimi

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.
 
A

Alberto

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
sheets gone from workbook 2
Manage a high number of worksheets in one workbook (Excel 2007) 4
Protecting workbook sheets 3
Limit on # of worksheets in a workbook 4
Many worksheets in a workbook 3
Can't add worksheets to a workbook. 1
Worksheet Limit in Workbook 2

Top