How many worksheets can I insert in a workbook
 

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

Thanks

Teresa Neves

How many worksheets can I insert in a workbook
 

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

How many worksheets can I insert in a workbook
 

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

How many worksheets can I insert in a workbook
 

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

How many worksheets can I insert in a workbook
 

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

How many worksheets can I insert in a workbook
 

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 !
---------------------------------------------------------------------------