How many worksheets can I insert in a workbook

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

Guest

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

Thanks

Teresa Neves
 
Computer Memory dependent.

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

See more on Help>Specifications


Gord Dibben MS Excel MVP
 
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
 
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!
 
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!
 
Back
Top