Max Number of Sheets

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Does anyone know if there is a max number of sheets you can add to a
workbook???

Wendy
 
Wendy,

according to the help there is no defined limit, it's
driven by the available memory. Lots of sheets with not
much on them or not so many with a lot on them!

Pete
 
Hi Wendy

The maximum number of sheets in a workbook is limited by available memory.
The max number of sheets that can, by default, be in a newly created
workbook is 255
 
you are only limited by memory. There is a maximum of 256 when you create a
new workbook, but you can add more after it is created.
 
You must log in or register to reply here.

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

Code to get Max Value in a perticular cell in ALL Sheets 3
MAX Value of a CELL in ALL sheets in a workbook 6
Active Sheet 2
Sequential numbering 2
return row header as answer 2
E-Mailing an existing file to a specific e-mail address 3
Comment boxes 2
Controlling sheet number during sheet add 3

Back
Top