limited scroll area

[dspel79082]

Hello,

I'm looking for an answer to a problem that I can't find with google.

I have received an excel file from a customer which is restricted to 200 rows.

There are no gridlines beyond row 200. I can't select cells beyond row 200.

CTRL E takes me to row 200.
There are no hidden rows or columns and neither the sheet or the workbook are protected.

I've checked VB and there is no code at all.

I've checked scroll area in page properties and it is blank.

I've even entered a larger scroll area in page properties in an attempt to override the scroll area. Nothing changed.

I can find nothing.

Can anyone tell me how the rows in this sheet could have been restricted other than scroll area in page properties or hiding?


Thanks!

 

[dspel79082]

I just edited the post to include the information that it isn't protected

Thanks!

 

[Andrew Poulsom]

Do you want to put the workbook on a share like Box.com and post the URL? You can remove any sensitive data.

 

[dspel79082]

It is here https://app.box.com/s/bgu1846f5tbagpk1y9rg

 

[Andrew Poulsom]

The rows below row 200 have a RowHeight of zero.

 

[dspel79082]

Wow! Thank you so much! I would never have thought of that.