ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Maximum Tabs/Worksheets in a workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/217903-maximum-tabs-worksheets-workbook.html)

cware

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

Thanks

David Biddulph[_2_]

Maximum Tabs/Worksheets in a workbook?
 
From Excel help for specifications and limits:
"Sheets in a workbook Limited by available memory (default is 3
sheets)"
--
David Biddulph

"cware" wrote in message
...
Does anyone know if there is a Maximum number of tabs or workseets there
can
be in a workbook?

Thanks




Gord Dibben

Maximum Tabs/Worksheets in a workbook?
 
Maximum default number in a new workbook is 255 sheets.

More can be added later depending upon available resources.


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 08:30:01 -0800, cware
wrote:

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

Thanks




All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com