spreadsheet is too large

[Guest]

I am working in a shared spreadsheet that has +/- 3000 rows. I don't know if
it's me or someone else, or why, but occasionally it maxes out at 65,000+
rows. this limits the usefullness of the scrollbar, as I only have to move it
down about 1/4" before I'm out of my working spreadsheet. Thusfar the only
solution is to copy the
the active area and paste it to a new sheet.
What is causing this problem and how do I fix it, when it happens?

 

[Guest]

Versions of XL before XL 2007 have a built in max of 65000 rows. It can't be
increased. Get XL 07 if you need more than 65,000 rows.

Dave

 

[Niek Otten]

Look here:

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am working in a shared spreadsheet that has +/- 3000 rows. I don't know if
| it's me or someone else, or why, but occasionally it maxes out at 65,000+
| rows. this limits the usefullness of the scrollbar, as I only have to move it
| down about 1/4" before I'm out of my working spreadsheet. Thusfar the only
| solution is to copy the
| the active area and paste it to a new sheet.
| What is causing this problem and how do I fix it, when it happens?