ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Limit on # of worksheets in a workbook (https://www.excelbanter.com/excel-discussion-misc-queries/42490-limit-worksheets-workbook.html)

HTC

Limit on # of worksheets in a workbook
 
Does anyone know the Excel limit on the # of worksheets/tabs allowed in a
workbook?

DS NTE

I have read that there are no limit on number of sheets in a workbook, but
you will get a memory problem with lots of sheets witch contain lots of
data. Maximum number of worksheets in a new workbook is 256, default is 3
(?) but you may change that.


knut
"HTC" skrev i melding
...
Does anyone know the Excel limit on the # of worksheets/tabs allowed in a
workbook?




JR

Go to "Tools", then "Options", then look on the "General" tab.

"HTC" wrote:

Does anyone know the Excel limit on the # of worksheets/tabs allowed in a
workbook?


FSt1

hi,
In xl help type the word Specifications
from the xl specifications...
Sheets in a workbook Limited by available memory (default is 3 sheets)

Regards
FSt1

"HTC" wrote:

Does anyone know the Excel limit on the # of worksheets/tabs allowed in a
workbook?


Dodo

?B?SFRD?= wrote in
:

Does anyone know the Excel limit on the # of worksheets/tabs allowed
in a workbook?


Have a look he

http://office.microsoft.com/en-us/as...992911033.aspx


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)


All times are GMT +1. The time now is 11:35 PM.

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