Mouse wheel not working on some sheets

One user reported this morning that the scroll wheel on her mouse would not let her scroll vertically on some sheets in multiple workbooks. These same workbooks work on most other computers. Two mor...

excel

typicalalex1
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

Copper Contributor

Oct 26, 2022

Thanks for the solutions, unfortunately this does not work with tables that have a sheet protection. I can't expect my customers to give me the password for the sheet protection. Can anyone tell me where I can create a bug ticket?

Tom__AMD
Copper Contributor
Oct 26, 2022
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.
- DKleadon
  Copper Contributor
  Oct 26, 2022
  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.
  - nseliga
    Copper Contributor
    Oct 26, 2022
    Right. Come on Pernille-Eskebo

Forum Discussion

Mouse wheel not working on some sheets

Resources