Unhiding rows on one sheet freezes Excel

[MrKowz]

Running into a strange bug. I have a sheet that will cause Excel's GUI to completely lock up (as if ScreenUpdating was turned off) if I unhide any rows while calculations are enabled. What makes this strange is that this sheet is relatively rudimentary with only basic INDEX/MATCH formulas, basic arithmetic formulas, and a Worksheet_Change event which monitors cells outside of the range I'm unhiding. While Excel is "frozen", I'm still able to interact with Excel, but I am not able to see anything happen (screen frozen, clicks still work, and Excel still seems like it's working in the background). Nothing in the statusbar indicates that Excel is attempting to calculate or that it's thinking.

I have tried manually running Application.ScreenUpdating = True in the immediate window, but nothing happens. If I turn off calculations before attempting to unhide the rows, it works as intended. But the moment I turn calculations back on, Excel's GUI locks up the next time I go to unhide rows.

This only happens to a single worksheet within my overall workbook. Other sheets work just fine.

Edit: This is persistent through a reboot. I have not yet tested it on another device.

Any ideas? Thanks!

 

[MrKowz]

Bump

 

[MrKowz]

Bump