Sep 16 2021 02:37 AM
Dear Excelers,
I am facing a scrolling issue in a particular sheet. This sheet doesn't scroll with the mouse (but scrolls with arrow keys) although all other sheets in the workbook are functioning as usual. Only the "sizing" sheet seems to have this issue. There are a lot of linked data in the "sizing" sheet. Can someone help me out?
NB: For security, I have wiped out all the data and kept the sheets only.
Thanks
Sandip Gumtya
Sep 16 2021 10:23 AM
Hmm... I have no problem scrolling the sizing sheet with the mouse.
Does the problem persist if you completely quit Excel then reopen the workbook?
If so, does it persist if you restart your computer?
Sep 16 2021 10:45 AM
Hi @Hans Vogelaar thanks for your reply. Yes, I have tried to use the same file in a different system but I am facing the same issue. Are you able to scroll all three sheets with the mouse? If so, what might be the issue at my end?
Sandip.
Sep 16 2021 11:12 AM
Yes, I can scroll all sheets in that workbook with the mouse.
I have also looked at the properties of the sheets in the Visual Basic Editor and didn't find anything special. So I have no explanation for the behavior that you experience, sorry.
Sep 16 2021 12:31 PM
SolutionIf scrolling by mouse means scrolling by mouse wheel staying on any cell, not clicking by mouse on scroll bar - yes, it doesn't work in my case as well.
In 'sizing' sheet rows starting from 9000 or so till end are hided. If unhide them mouse wheel scrolling works, please check in attached. Not sure what is behind this effect.
Sep 19 2021 09:21 PM
Hi @Sergei Baklan ,
Unhiding the rows from 9000 did the trick but still unclear what was causing this. Anyway, thanks for your inputs.
Thanks
Sandip.
Sep 20 2021 01:15 AM
@sandipgumtya365 , you are welcome. I can't reproduce that on new file and not sure what's the reason exactly, will try to investigate some later.
Feb 25 2023 12:03 PM
I just had the same type of thing. Workbook with multiple worksheets. One worksheet was created by me, another one was generated by a system and emailed to me as a template. Using the template I created other worksheets.
I could mouse wheel scroll on the created worksheet, but none of the template worksheets. Followed a number of recommendations but could not get past it.
When I saw this, went to the end of one of the template sheets, highlighted the row, unhide, then had to move the cursor until it was a double line, clicked it and it showed a number of lines. Could scroll after that with the mouse scroll wheel.
Sep 16 2021 12:31 PM
SolutionIf scrolling by mouse means scrolling by mouse wheel staying on any cell, not clicking by mouse on scroll bar - yes, it doesn't work in my case as well.
In 'sizing' sheet rows starting from 9000 or so till end are hided. If unhide them mouse wheel scrolling works, please check in attached. Not sure what is behind this effect.