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.
Logan Galloway commented
We are encountering this issue on Dell Precision (5530, 7510 & 7520) equipped with both a 4k touch display and NVIDIA Quadro discreet graphics. Disabling hardware acceleration does not help. The laptops either have a Quadro M1200, M2000, M2200 or P1000 "card"
We do not have the issue if connected to a Dell WD15 docking station connected to standard 1920x1080 24'' monitors and the laptop screen is closed.
Specifically you need to make sure you have USB c 3 cables of High speed HDMI cables between your laptop and monitors...then make sure you are on the latest release of Office 365.. and don't try to use a Surface laptop with the large monitors...then you will see there will not be a real problem. I had to get rid of my Surface laptop, went back to Toshiba with the USB C 3 thunderbolt cables no more than 4 ft, to the port replicator, High Speed HDMI cables from the replicator to the 2-35" monitors. it works fine. It seems to have to do with the ability of the connectors and cables to support the displays with Windows.
Daniel Limcher commented
I would like to add that this issue happens on our notebook monitors, which are Hi-DPI, more than anywhere else.
Intel HD Graphics 630 + NVIDIA Quadro M1200
Daniel Limcher commented
I work for a financial investment firm, and the entire team has been very disgruntled with how slow excel is on Hi-DPI monitors. We all use $3000 Dell Precision 5520s with dedicated graphics and the issue continues to persist. My workaround has been to downscale my resolution to 1080p (which makes reading fuzzy, but time efficiency is paramount).
We see the grey boxes when we scroll, but they are temporary. The real issue is how slow the rendering is.
Upon talking to others in the financial community, it seems like this is a common problem.
Cricket Benitez commented
It's very annoying that this issue was reported two years ago and is still happening. I purchased a lenovo T580 and S340 and am getting the grey screen when I scroll down on both while using Excel.
J Feiler commented
I can confirm this issue is not only unique to external displays. I have two users, both Dell XPS 13 9360, who have this issue when working on their notebook monitor. Occurs on 32-bit and 64-bit Office. Steps I have taken:
-Disabling graphics acceleration
-Running Excel in safe mode
-Running Excel in compatibility mode (Win8.1, Win7)
I've also noticed that Excel produces these grey boxes when on a notebook screen, but I can reproduce the issue with black boxes on an external monitor on my Dell Precision 5520. I'm not sure if that speaks to two different issues or not.
I will experiment with not running Excel in full screen, as some users have noted. Still, alarming that this issue was first reported in 2016, and it's still a persistent issue.
I have the same issue. Open Excel file, when I scroll down to view more, the view-able contents become grey. The file size is only around 80MB.
It seems that opening and closing the ribbon menu forces Excel to redraw. It's the only workaround I've found so far--but its very tedious to do that everytime you scroll the worksheet.
Lenovo T470p. However, this happens on several other Lenovo laptops, Surface Pro 3, and Surface Go.
For me, hitting <page down> then <page up> in quick succession clears the unwanted grey boxes from the open work sheet, but it is only a work-around, it does not fix the underlying issue.
Same problem. I have an second BENQ GL2460 monitor which was not rendering Excel files properly. Doing a repair did not fix it. Nor did reinstalling Office. The fix for me was Settings - Display - Advanced scaling settings - 'let windows try to fix apps so they're not blurry'.
Still happening to this day. This is just on a laptop running Windows 10 with no secondary monitor. I did an Online Repair for Office365, setting true to false in the manifest and disabling hardware acceleration. Had to make a poor guy use the online version of Excel to open the 4 files he uses hourly. If only M$ could get their stuff together.
Try stepping down your connection to a monitor through multiple adapters. Right now I go from Monitor:HDMI>HDMI:Thunderbolt>Thunderbolt:Laptop. This resolved my issue as my monitor could not process my advanced graphics even though the only application this struggled on was excel.
What do we need to do to get MS to action this issue? It was initially reported in June of 2016 and it has been 2.5 years
i have the same issue, excel opens and part of the file is greyed out and the program freezes, the difference is I am NOT using an external monitor. I have tried both types of repair options & neither fixed the issue.
i tried to change the manifest file but it said i needed admin rights even though my login has admin rights. any ideas ?
I'd like to add that this issue started for me at least when office 365 updated to the new version of office (2019).
The specs for my machine are as follows:
Dell XPS 15 9560
intel HD 630/Nvidia GTX 1050
Same problem. Dell XPS 15 9570 4K screen.
Scrolling is very slow on Excel and gets stuck in a loop of flashing grey blocks if I use touch.
I also lost the text on the top nav.
Also experiencing the same issue on my XPS 15 9560 with the 4K display.
Excel is absolutely unusable from this issue. When will this be fixed?
SOLVED: I have found that this is caused by my machines GPU is too advanced for my 4K screen. One way to prevent this when displaying is to add adapters between your machine and monitor which help 'dumb down' my machines graphics. I did this by connecting to my monitor using 2 adaptors (My Machine>Thunderbolt>HDMI>4 K Monitor). From here it took some display setting changes but the adapters helped solve most of my display issues.