Maximum Tabs/Worksheets in a workbook?

C

cware

Does anyone know if there is a Maximum number of tabs or workseets there can
be in a workbook?

Thanks
 
D

David Biddulph

From Excel help for specifications and limits:
"Sheets in a workbook Limited by available memory (default is 3
sheets)"
 
G

Gord Dibben

Maximum default number in a new workbook is 255 sheets.

More can be added later depending upon available resources.


Gord Dibben MS Excel MVP
 

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

Menus and Lookups 5
Workbook won't allow me to insert worksheet. How can I add one? 4
Copy range from one worksheet and paste to multiple worksheets 10
Excel Compare numbers on 1 tab to other tabs in workbook. 1
Recover lost excel tabs/spreadsheets from workbook 2
DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? 3
Need a formula 3
Maximum tabs in Excel? 4

Top