Forum Discussion
Mouse wheel not working on some sheets
- Jul 25, 2022
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.
DKleadon Understood. Can you ask them to give you a version, still protected, with column and row formatting enabled? That might work. It is a check box option in the sheet protection dropdown.
Tom__AMDa that's a good tip!
But this can't be the final solution.
It would be enough for me if Microsoft takes note of the problem.
- nseligaOct 26, 2022Copper ContributorRight. Come on Pernille-Eskebo
- Tom__AMDOct 26, 2022Copper ContributorCompletely agree. Somehow new functionality continues to pop up that decreases the utility of a great tool. Horizontal auto sum used to work. Now only vertical. Sigh........
- tmetcalf13Nov 06, 2022Copper Contributor
Tom__AMD - Well, that is an odd solution and just tells you to what level MS goes with the validation and verification processes. Glad we finaly have a solution. Thanks for those that kept pushing on...I honestly just gave up and hoped for a fix whenever MS secretly updates our stuff. 🙂