Excel Worksheet Allowing Scroll Beyond Data

[MrMaker]

Hi all,

My Excel365 has just started behaving strangely.

I create many simple reports of data in a month and for some reason (shown in the example below) the report has 11 rows of data but the worksheet allows scrolling way beyond that, indicated with the arrow on the image showing the small scroller).

Previously these reports just allowed scrolling for the data visible (there is no hidden data below, I have checked)

Any ideas?

Thanks in advance

 

[Peter_SSs]

My Excel365

Please put that information in your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I create many simple reports of data in a month ...

Without knowing exactly how your are doing that it is hard to have much idea but if you press Ctrl+End where do you end up?

 

[MrMaker]

It was a difficult one to explain.

Essentially, I have a master report of 5000 rows which then gets split into 500+ reports of about 11-12 rows of data (using some splitting vba code).

On the split report the scroll bar never used to be so tiny (as in the image), which suggests to the end user there is more data below.

Frustrating, as it's just started doing this today

 

[MrMaker]

And sorry, control + end takes me to the bottom cell of data (as expected)

 

[Peter_SSs]

Try saving the workbook, close Excel and reopen.

 

[MrMaker]

No joy with that unfortunately

 

[MrMaker]

Out of curiosity I've just re-run the report process on a historical version of the workbook (which did work) and this too is now doing the strange scroll thing.

Infuriating

 

[Peter_SSs]

Any chance that you could upload a copy of a workbook with the small scroll bar and any sensitive data disguised to DropBox/OneDrive etc and provide a shared link here so that we can see if the behaviour is replicated on our systems and investigate reasons/solutions?