Maximum number of worksheets in XL

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

Guest

Could any one please let me know the maximum number of sheets we can have in
the one excel file. Thanks in advance.
 
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, 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
 
Duane

Maybe you were thinking of..........New workbooks default sheets is limited to
255 at Tools>Options>General>Sheets in a new workbook.


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