Maximum number of worksheets in XL
 

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

It will depend on your computers memory. I know someone who tried and said
the computer crashed at around 3000. But those were with no data on them.
(that is hearsay - I didnt witness it) (I believe it used to be limited to
255)

"raju" wrote:

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

raju, from help,

Maximum number of sheets in a workbook Limited by available memory
(default number of sheets is 3; the maximum number of sheets in a default
workbook is 255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"raju" wrote in message
...
Could any one please let me know the maximum number of sheets we can have
in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

Duane

Maybe you were thinking of..........New workbooks default sheets is limited to
255 at ToolsOptionsGeneralSheets in a new workbook.


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 11:27:02 -0800, Duane
wrote:

It will depend on your computers memory. I know someone who tried and said
the computer crashed at around 3000. But those were with no data on them.
(that is hearsay - I didnt witness it) (I believe it used to be limited to
255)

"raju" wrote:

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

I took a look. 255 the maximum # of default of sheets that a workbook can
start with. It is not the limit to number of sheets a workbook can contain.
The limit is only by memory. I had no problem adding 1000 but it was
starting to slow down the copying process (my computer is a few years old).
I couldnt imagine needing much more than that anyway.

"Gord Dibben" wrote:

Duane

Maybe you were thinking of..........New workbooks default sheets is limited to
255 at ToolsOptionsGeneralSheets in a new workbook.


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 11:27:02 -0800, Duane
wrote:

It will depend on your computers memory. I know someone who tried and said
the computer crashed at around 3000. But those were with no data on them.
(that is hearsay - I didnt witness it) (I believe it used to be limited to
255)

"raju" wrote:

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

I can't imagine using even 255 sheets in a workbook<g


Gord

On Thu, 16 Nov 2006 13:05:01 -0800, Duane
wrote:

I took a look. 255 the maximum # of default of sheets that a workbook can
start with. It is not the limit to number of sheets a workbook can contain.
The limit is only by memory. I had no problem adding 1000 but it was
starting to slow down the copying process (my computer is a few years old).
I couldnt imagine needing much more than that anyway.

"Gord Dibben" wrote:

Duane

Maybe you were thinking of..........New workbooks default sheets is limited to
255 at ToolsOptionsGeneralSheets in a new workbook.


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 11:27:02 -0800, Duane
wrote:

It will depend on your computers memory. I know someone who tried and said
the computer crashed at around 3000. But those were with no data on them.
(that is hearsay - I didnt witness it) (I believe it used to be limited to
255)

"raju" wrote:

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.

Maximum number of worksheets in XL
 

Thanks everyone,

Great!!!

It was pretty useful for me as i was supposed to split my files in two excel
file. Now I can continue with existing one.

Still i i'm having one doubt. Whether i can add 255 sheets in excel file as
my system runs on 512 MB RAM.

Thanks,
raju


"Paul B" wrote:

raju, from help,

Maximum number of sheets in a workbook Limited by available memory
(default number of sheets is 3; the maximum number of sheets in a default
workbook is 255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"raju" wrote in message
...
Could any one please let me know the maximum number of sheets we can have
in
the one excel file. Thanks in advance.