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?

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"clueless" wrote:

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?

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"clueless" wrote in message ...
|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?