How many worksheets can I insert in a workbook

T

Teresa Neves

I need to know how many sheets can I insert in a workbook in Excel 2003.

Thanks

Teresa Neves
 
G

Gord Dibben

Computer Memory dependent.

Max default worksheets is 255 but you can add more after.

See more on Help>Specifications


Gord Dibben MS Excel MVP
 
J

Jim Cone

Seems like I can recall some tests that were run that indicated somewhere
over 1000 sheets, Excel had problems separate from the memory issue?
Of course with 1000 sheets in a workbook you may have lots of problems anyway.<g>
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

I need to know how many sheets can I insert in a workbook in Excel 2003.

Thanks

Teresa Neves
 
R

RagDyer

Just as a topic of conversation, since I doubt anyone would go to these
lengths:

Max sheets is 5,447

As tested by Dana in XL07,
And verified by Harlan in XL03.

Attempting to insert the 5,448th caused both versions to crash!
 
J

Jim Cone

Thanks for the update.
My brain cell with the number in it was only off by 4000. <g>
I created 900+ sheets once, but couldn't find a use for them.<g>
Jim Cone


"RagDyer" <[email protected]>
wrote in message
Just as a topic of conversation, since I doubt anyone would go to these
lengths:

Max sheets is 5,447

As tested by Dana in XL07,
And verified by Harlan in XL03.

Attempting to insert the 5,448th caused both versions to crash!
 
Top