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

One note creating multiple tabs when collaborating? 0
Use a variable in a ShapeRange.Increment 0
Consolidation Table from Different Excel Tabs with Different Format 1
How to set tabs in work document 0
How to display the merge function "url" of a picture? 0
Use a master workbook to carry over changes to multiple workbooks 1
Turning off automatic calculation 0
Recover lost excel tabs/spreadsheets from workbook 0

Top