Excel Screen Tearing

[swarmo]

Hi everyone. I have just discovered this very weird bug occurring in excel 2016. It only seems to happen to sheets that are placed after the sheet making the change.
When I change a cell that is linked to a cell on another sheet, I get this weird tearing. I have to scroll down then scroll back up for it to refresh.

I have attached three photos. The first photo has no bugs. The second photo I change a cell with a dropdown list, and the updated data on the sheet below becomes visible. The third photo is of the sheet directly below. If I move the M Illuminance sheet in front of the Calculator sheet, the problem doesn't occur.

Anyone have any ideas on whats causing this?
Cheers

 

[swarmo]

Solved it. It was only occurring after I ran a macro. In order to stop it from screen tearing, I added the code below at the end of the macro. This has solved the glitch.

Sheets("M-Illuminance").Visible = False
Sheets("M-Illuminance").Visible = True

 

[Michael M]

Have you thought that it might be something in the macro causing the issue?
Why not post the code ??