Maximum amount of worksheets in single file
 

Hi,

What it the maximum number of worksheets that can be used in one Excel file.
I'm using Excel 2002 if that makes a difference.

Thanks.

Maximum amount of worksheets in single file
 

Limited by available memory

Biff

"stuart" wrote in message
...
Hi,

What it the maximum number of worksheets that can be used in one Excel
file.
I'm using Excel 2002 if that makes a difference.

Thanks.

Maximum amount of worksheets in single file
 

For the fun of it I once created a workbook with 1000 sheets.
--
Brevity is the soul of wit.


"Biff" wrote:

Limited by available memory

Biff

"stuart" wrote in message
...
Hi,

What it the maximum number of worksheets that can be used in one Excel
file.
I'm using Excel 2002 if that makes a difference.

Thanks.

Maximum amount of worksheets in single file
 

The problem I have with multi-sheet workbooks, is that of managaing them. I
have one book with only 40 sheets, but keep most of them hidden and only call
each up to visibility by macro from a MainMenu and then automatically re-hide
each when I'm finished with it and return to MainMenu.

hth
Vaya con Dios,
Chuck, CABGx3



"stuart" wrote:

Hi,

What it the maximum number of worksheets that can be used in one Excel file.
I'm using Excel 2002 if that makes a difference.

Thanks.