Number of worksheets

[Guest]

I am using Excel 97.

Apparently Excel 97 can only support 255 worksheets, but I have a workbook
which has over 400 worksheets!

Can someone please tell me how and why the software has allowed it and what
are the implications if any?

If it does support it without any problems what would be the absolute
maximum number os worksheets it could hold?

 

[RagDyeR]

The number of WSs is limited only by the memory on your machine.
That 255 number is just the number of sheets that can be created in a new WB
*automatically*.

Try this:
Set the option to 255 sheets for a new WB.
Open that new WB.
Right click in the last tab (just so new sheets are appended to the end) and
choose "Select All Sheets".
Right click again and choose "Insert", then Worksheet,
and you'll see that you now have 510 sheets.

You can keep going this way until you run out of memory.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am using Excel 97.

Apparently Excel 97 can only support 255 worksheets, but I have a workbook
which has over 400 worksheets!

Can someone please tell me how and why the software has allowed it and what
are the implications if any?

If it does support it without any problems what would be the absolute
maximum number os worksheets it could hold?