Unable to scroll in one particular sheet only

[CRE_finance_guy]

One of the sheets in my workbook has been imported from another workbook. On this particular sheet, scrolling (with my mouse wheel) is somehow disabled. I can scroll just fine on all the other sheets.

Here are a few things I tried:

• I went to the sheet properties, because I assumed there was something in the ScrollArea property that was causing this. But the ScrollArea property is blank.
• There aren't any macros affecting the sheet, and in fact, the workbook is saved as an xlsx, not xlsm, so I don't think a macro is a potential culprit at all.
• I went to "view" to see if this was due to a frozen pane, but there are no frozen panes.

I'm sure there's a simple explanation, but I'm stumped. Does anyone have any ideas about how this could be possible?

Thanks in advance for any help!

 

[awoohaw]

can you try to rebuild the workbook entirely? Moving all worksheets into a new workbook?
But, before doing that, copy the culprit sheet into a new book and see if the problem still exists?

 

[CRE_finance_guy]

can you try to rebuild the workbook entirely? Moving all worksheets into a new workbook?
But, before doing that, copy the culprit sheet into a new book and see if the problem still exists?

In theory, sure. But there are about 30 sheets and it would be a lot of work. I was just hoping someone might know what the issue could be. I feel like I've covered most of the basic possibilities (macros, frozen panes, or a restriction on the sheet properties). I imagine someone out thee must know what the cause of this could be. So odd.

 

[awoohaw]

You can move all 30 sheets into a new workbook in one step.
Highlight all the worksheet tabs you want to move, right click, copy or move, to book: Select "New Workbook". Be sure to click "CREATE A COPY" (I wish this clickbox was at the top of the form!)