Maximum number of worksheet tabs?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone know the maximum number of worksheet tabs (don't feel like trying by trial and error)?
 
Hi Ryan

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
 
Ryan,

This is a previous post from Charles Williams, it must be more than you need


The maximum number of worksheets that you can create by using
Tools--Options-->General-->Sheets in New Workbook is 255 in Excel2002, which
is the same as in Excel2000.

NOTE that after you have created a workbook with 255 sheets you can go on
adding lots more, either manually or using VBA (this is also the same as
with Excel2000)

I am sure there is a limit but in practical terms its several thousand or
tens of thousand... my personal record is over 20000 sheets before I got
bored.

The real limits are Excel memory and filesize.

(ignoring the Excel 97 VBE limit of about 800 sheets).
hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Ryan said:
Anyone know the maximum number of worksheet tabs (don't feel like trying
Click to expand...
by trial and error)?
 
Back
Top