ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Limit of # of tabs (https://www.excelbanter.com/excel-worksheet-functions/35434-limit-tabs.html)

Dan S

Limit of # of tabs
 
Is there a limit to the # of tabs (worksheets) you can have (version 2003)?

Dan

Ron de Bruin

Hi Dan

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dan S" wrote in message ...
Is there a limit to the # of tabs (worksheets) you can have (version 2003)?

Dan




Barrie Davidson


From Excel's help (search on "Excel specifications and limits ")

Sheets in a workbook - Limited by available memory (default is 3
sheets)

Regards,


--
Barrie Davidson


------------------------------------------------------------------------
Barrie Davidson's Profile: http://www.excelforum.com/member.php...o&userid=16930
View this thread: http://www.excelforum.com/showthread...hreadid=387334


Gord Dibben

If you check out Help and "Specifications" you will see the number of
worksheets is limited by available memory.

Lots of other neat things under this help topic.


Gord Dibben Excel MVP

On Thu, 14 Jul 2005 13:17:02 -0700, "Dan S"
wrote:

Is there a limit to the # of tabs (worksheets) you can have (version 2003)?

Dan




All times are GMT +1. The time now is 05:01 AM.

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