just create a workbook with 100 sheets

select all sheets

type1 in a1
type1 in e10000

select sheet1

save

look at size.

nuf said.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


deko wrote :

I've heard that the maximum number of worksheets allowed in an Excel
workbook is 255. Is this urban myth? I just had a look at "Excel
specifications and limits" for XL2003 at
http://office.microsoft.com/en-us/as...033.aspx?mode=
print and the Maximum limit is defined as "Limited by available
memory (default is 3 sheets)". Is this true only for XL2003? What
about XL2000?

The only thing I've read about chart limitations is in regard to
"Worksheets referred to by a chart" - which is no an issue for me.

So it's possible to have 500 worksheets and 2000 charts? The only
limitation is memory/processor?

Thanks in advance.