Forum Discussion
Mouse wheel not working on some sheets
mweaver77 I've found the reason for the issue i have been facing but i haven't found out why this has suddenly become a problem. Obviously an update of some kind as more and more users have been reporting this issue.
The issue for me is down to hidden rows and their row heights.
I found that the hidden rows at the bottom of the worksheets all had a height of 0px. Un-hiding these rows and changing their height fixed the issue.
These spreadsheets are generated from a template and nothing has changed with them for several months but suddenly the hidden rows are causing an issue.
mweaver77 I've found the reason for the issue i have been facing but i haven't found out why this has suddenly become a problem. Obviously an update of some kind as more and more users have been reporting this issue.
The issue for me is down to hidden rows and their row heights.
I found that the hidden rows at the bottom of the worksheets all had a height of 0px. Un-hiding these rows and changing their height fixed the issue.
These spreadsheets are generated from a template and nothing has changed with them for several months but suddenly the hidden rows are causing an issue.
In 365. This worked. Thanks. Multiple sheets in one workbook decided to not vertically scroll with mouse. I had hidden rows, so highlighted each sheet then unhide. I noticed that the full number of rows was not available / visible. Should be 1,048,576.
I then clicked the top left box to highlight the entire sheet and scaled all the rows with the mouse. Now all 1M plus rows are visible and vertical scrolling works.
Thanks for the "fix". Nicely done.
No reason or logic behind why it happened. One day all sheets would vertically scroll with Logitech M705. The next some would not. Anyway, it all works now. Thanks again and hope this helps others.