Scrolling doesnt work on a few sheets

Occasional Visitor

Hi!

 

My problem is that on specific sheets in my excel file I can’t scroll up and down using the mouse wheel.

 

-it works on other sheets in the file

-up and down arrows do work

-scrollbar works

-no panes frozen

-no scroll lock

-scrolling enabled in settings

-when my coworker opens the file, she can scroll using the mouse wheel

-reopening the file doesn’t fix the problem.

 

Seems to be a bug that only comes up for me. Any suggestions? 

Thanks a lot in advance

3 Replies
I've had this happen before. I had to create a new tab and copy the data. you might be able to copy the tab and have it work, but it's best to just create a new one. It appeared to be a glitch in the tabs formatting. When I copied the format it would sometimes copy the glitch.
When this happens, I recommend totally resetting all views in the sheet. This includes removing filters (Not only clearing but removing), unfreezing panes, and changing the view away from the present. If you're in Normal view, go to Page Break Preview then back to Normal.
I'm having this same issue...

It's randomly appeared in excel files that up until now worked fine, and they haven't been edited.

Freeze panes aren't causing it and it's not as simple for us to just recreate/copy the data to a new sheet.

Does anyone have any knowledge or advice for this bug?

Thanks