Fix the black and grey boxes that cover the screen when you scroll
Whenever I scroll too fast in Excel on my PC black and grey boxes appear everywhere and cover what I am working on. This is incredibly frustrating because there is no way to get rid of the boxes.
This only happens on my external display and it only happens in Excel.
Please fix this issue.
I am not seeing new recent activity in this space. It is possible you are seeing this less due to our on-going performance investments including in speeding up our grid rendering. Details on latest speedups are at https://aka.ms/excel-perf-improvements.
That said, if you still are experiencing this please provide specifics on your configuration and monitors… better still please send feedback about the problem from within Excel (go to Help > Feedback), which will include some diagnostics to aid our investigation.
The only suggestion I have which I use for this problem, is to change slightly the scaling up or down - this can temporarily remove the black boxes, but is only a get around to reduce frustration - not a fix- I think that is a job for Microsoft
I have this issue. It occurs on my secondary display ONLY when using excel in full screen. I work around it by using a window that is slightly smaller than full screen. I have tried all to the suggestions out there. It is extremely reproducible.
my system is a Surface Pro 4 with an i7 and a UHD samsung running form the video port.
does it help if you install the 64bit version of office?
I just purchased excel and I am having this problem on my 2K and 4K monitor. Makes the program not-usable.
Copy the whole sheet to a new work book. You will realize the error in format.
I had the same exact problem and spent hours with my IT guy trying to fix it. From what we learned, this issue is happening on 4K monitors. We did a lot of things that didn't work (reinstall, online fix, changing resolution, disabling monitor acceleration....) We ended up calling MS. Bottom line, we ran Excel in safe mode. This corrected the issue. We believe that there is a programing incompatibility between 4K monitors and Excel. In Safe Mode, Excel does two things; disables add-ons and runs in VGA monitor mode. Disabling add-ons helped a bit,
It is my opinion that programing has to catch up with hardware technology (especially 4K monitors)
Rob H commented
Precisely the issue on a Surface Book with a Samsung S34E790C 34" display attached via surface dock (displayport 1.2). Please fix!
I read one suggested solution which was to do an on-line repair of MS Excel - tried this but it didnt work. I do not think there is a solution other than perhaps revert to an old version of Excel or perhaps and old version of windows.
It needs MSoft to sort it, but they seem very laid back about this problem.
Meanwhile, to read stuff blacked out, I fiddle with the scaling bar - that wil get rid of the boxes temporarily but of course the problem re-occurs elsewhere
I have a Lenovo Yoga 910 (7th Gen i7 with Intel HD 620) with a 4K display.
This issue is bugging me so much! Have tried multiple versions of office (including for Business), clean install of Windows, different version of display drivers etc. Nothing gets rid of the horrendous scrolling. My current workaround is to run with dpi scaling off, so on my laptop it appears to be 1080p (desktop scaling of 200%). It doesn't look great, but its at least smooth with minimal gray boxing.
I was able to reproduce the problem on my Surface Pro 3 by reducing the scaling percentage.
Same issue. Running a Surface book i7 with 16Gig of memory and the Geforce GPU. The problem occurs on the second monitor, when the excel window is about 60% of the screen or larger. When scrolling quickly these black and or gray boxes appear sometimes they go all the way across the screen sometimes not. Sometimes they can be eliminated by scrolling back the other way and waiting a second then scrolling again slowly. Sometimes this eliminates all the boxes, sometimes part of the boxes, and sometimes portions of the black or grey areas are replaced with the other color. I have reinstalled excel and Office several times and the issue remains.
The second monitor is a LG 27 in LED 4K monitor connected to the surface book through a surface dock.
It has occurred since the first time I used excel with this system. It is becoming sad that Microsoft has not fixed this issue yet.
I have the same problem - sometimes the white or black boxes/lines cover just half the cells in each line/row. It happens only in excel on laptop (lenovo Yoga 900) screen or external monitor .
Is this an excel issue or Lenova and how can it be fixed?
Jim Davis commented
Running Excel 2007 and Win 7 x64. Just got a 4k TV using as a monitor.
Excel was fine day 1 , then got these random black boxes filling cells as the screen refreshed with new data.
Thought I was up the creek. Then realized I had invoked the MAGNIFIER (Win Key and Keypad +) Utility , and kept it running.
Once I shut that down , Excel was fine again.
Not sure this will help any of you, but may provide a hint as to what the underlying issue it.
Same issue here with an Intel NUC NUC6i7KYK running windows 10 build 1607 which uses the integrated iris pro 580 attached to a 4k screen with scaling set to 200%.
The issue occurs when the excel window is above a certain size, i.e. maximized or set to about 90% of the screen real estate, if I size the windows down to about 85% of the screen the issue does not occur. It looks like the excel display buffer has issues with a window over a certain size.
From some searching around the internet it looks as though this issue has been around for over a year, its only going to become more of an issue with higher resolution displays becoming more common.
i have the same issue on my external 4k monitor.
if have have the windows scaling at 200% its fine but i set it to 150%, 125% or 100% i'm having these black boxes.
running at 200% is not an option for me as it take away to much real estae of the screen.
I actually fixed it for now by using right clicking on the Excel icon, and choosing 'Troubleshoot compatibility' Answering the questions in the wizard, 'Troubleshoot Program' option. Then choosing 'The program opens but does not display correctly' - This has given me a lower res version for now, the UI is now slightly larger on my dell 27" 4k second monitor, than it was before, and at 100% I can columns A > V clearly, on scrolling or resizing, no grey and black boxes! Hope this helps you use it temporarily!
I have 2 monitors side by side in portrait mode and see the same issue when spanning across the screens to create one big sheet. Only ever happens on Excel and only happens when I'm spanning.
I have Dell PC (64bit/W10), Dell External dock (HDMI & DP) and Dell monitors so I don't think it's a compatibility issue.
Please fix this issue as working with complex spreadsheets is becoming impossible.
It usually happens with high resolution displays, full HD or higher.
It also happens even with Windows 1607 64 bits, updates to the fullest, and video drivers updated as well.
Disabling hardware acceleretion does not solve it.
Running OfficeCAT does not solve it.
There is something which could be a buffer overrun when excel is using a large portion of a high resolution screen - try a setup with multiple UHD monitors to try to reproduce.
Brad Thurber commented
addendum to my prior post
(approx million pixels) should be
(approx 5 million pixels)
Brad Thurber commented
This is happening to me as well. It seems this may have something to do with really high resolution displays. My external monitor is UHD ("4k"). Something I have noticed that I don't believe has been pointed out yet is that this behavior seems to manifest itself (for me anyway) when the Excel window is at least 60% of the screen (approx million pixels). If the Excel window is less than that, I don't see the boxes. Sure seems like some sort of buffer overrun to me.
I have tried LOTS of troubleshooting steps to attempt to fix this. Please see my post here
This is a real bug. It is only going to get more prevalent as people adopt displays that go beyond the old HD "norm".