Excel screen rendering issues when resizing rows and columns (Solution Sought)

Question

Hi,

I've recently been experiencing strange graphical issues with Excel when resizing columns and rows and also when freezing panes.

When making any of these changes, it seems as if the screen is trying to render a different resolution, which results in either the screen shifting position, the pointer not aligning to cells, changes to zoom, areas of the worksheet just black, freeze panes moving to random places and other strange graphical glitches.

Clicking off and back on to the worksheet temporarily fixes the issue but it soon reappears. These issues seems to come and go depending on the day but it has become so bad recently it sometimes prevents me from actually being able to work.

It's even happening with some VBA user forms I run in my workbooks.

I run a multi screen set up, with the main screen being a 3440 x 1400 ultrawide and the other a 2560 x 1440 laptop screen, so I wonder if this is the cause of the issue and if there's a way to fix it without sacrificing a screen. (My laptop is a Legion 7i, which has a 4080 driving my 2nd screen via display port over thunderbolt.)

I've had this happen a few years ago and I remember that switching off accelerated graphics fixed it. However that option has now been removed and so wondering if there's any other way to stop Excel failing this way?

Thanks,

Alex

Answer 1

You may try this option.

File > Option >Optimize for compatibility (Application restart required)

Answer 2

Due to without environment at hand, I’d suggest you raise support ticket to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. That support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Thank you for your understanding.

Answer 3

Thank you,

Sadly the issues are still occurring though they do seem to be less severe than before.

Alex