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

Thanks

Teresa Neves

Until it runs out of memory, it is system specific.

Teresa Neves wrote:
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 HelpSpecifications


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:31:03 -0700, Teresa Neves
wrote:

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

Thanks

Teresa Neves

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)

"Teresa Neves" wrote in message ...
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!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Teresa Neves" wrote in message
...
I need to know how many sheets can I insert in a workbook in Excel 2003.

Thanks

Teresa Neves

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"
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!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------