Excel display issues

Question

Hi all,

Ive always used Office Pro Plus 2016 (Excel) in Page Layout view (in View tab).

However, as of 25/06/2017 i am unable to see the highlighted cells (theyre all white!) and when i attempt to highlight a field it goes black.

I now can only view the correct formatting and continue to highlight cells in Normal view.

Answer 1

To confirm I understand correctly: in a new copy of the file simply adding the footer, with nothing custom in it causes the problem.

Since you can recreate the problem, I agree it is something for MS to look at.

The best way to get MS developer's attention is to submit a bug report to "UserVoice". That is now the place MS is constantly monitoring for user suggestions AND bug reports.

In Excel 2016 go to File menu > Feedback command > Send a Suggestion button. This will take you to the appropriate "userVoice" forum. Create a new "suggestion" there. Include the word "Bug" in subject line. Describe the problem, you can copy your comments from here. If you can create an example file, with no sensitive data in it, with text explaining how to trigger the problme and upload it to your onedrive and add a share/edit link to it, and put a link to it in your suggestion, MS will be more likely to act on the issue. No promises.

Good luck

Answer 2

Hi bud

Created a new spreadsheet and copied over the one page of data and added a new footer

As soon as i did it removed the highlighting.

Looks like this is a microsoft issue. 

This is extremely annoying :(

Answer 3

OK, glad you found it on your own.

From your description, it sounds exactly like you put it, some form of file corruption. The tricky part is figuring out what is causing it.

So rather than copying the whole footer, try to manually recreate it one element at a time (do not copy paste) to see if you can figure out which element of the new footer is causing the issue.

Answer 4

Thank you for your message, although the suggestions youve made did not work.

I have however found the root of the problem.

I have duplicated the document into a new excel spreadsheet. As i went through the formatting, i notice that i lose all the highlighting and get the corruption when adding the footer in.

The footer in the original document has been there for a very long time so im not sure why this is happening now?

Answer 5

Hi Farty: My name is Ron.

This is a bit of a long shot. Some people have reported various "display issues" in Office 2016 applications. Typically this happens on computers running display(s) above "HD" (1920x 1080).

For some people the fix is simply a matter of adjusting one or more options in Excel: HARDWARE ACCELERATION - COMBO OF OPTIONS TO BE INVESTIGATED / CHANGED https://answers.microsoft.com/en-us/msoffice/forum/msoffice\_word-mso\_windows8/office-365-really-slow/b2656170-a2cd-47d5-8f22-35ab6027d3df?page=4&msgId=99dbb0f8-74b5-49d9-b4fc-59dd2dd15337

https://support.office.com/en-US/article/Why-do-I-get-a-stopped-working-message-when-I-start-my-Office-application-52bd7985-4e99-4a35-84c8-2d9b8301a2fa

I systematically went through every single option disabling things that might effect it, and the dumbest solution and dumbest option for me was simple... . By “toggle”, I mean change current setting, for these 2 or 3 options (depending on version) try all of the combinations of the settings on and off. The specific options you see depend on the Office application and its year (2010/2013/2016).

1. Go to File menu > Options command > Advanced option
2. In the Display section: Toggle the check box for "Disable Hardware Acceleration" (2010 / 2013 / 2016)
3. Also try toggling the check box for “Use subpixel positioning to smooth fonts on screen” (2013 / 2016)
4. In the General section > Toggle the check box for “feedback animation” (2010 / 2013?)
5. Apply the changes by clicking on Ok button at bottom of the dialog box
6. Close Word normally
7. Restart Word

https://fud.community.services.support.microsoft.com/Fud/FileDownloadHandler.ashx?fid=abacb31d-d431-4d3a-b9b4-b93c34647ed7 (Screen Cap of 2016 Options Dialog with the options highlighted)

This issue is most noticeable on machines with dual video chip sets, ie. video support built into the CPU plus an external graphics card.

It didn’t have an immediate effect until I closed and re-opened Word, then it was fine. I unchecked the box and the screen flickered and it was sluggish again until I repeated the steps. The combination of the two options for whatever reason seems to have fixed for me.

Another option to try is this:

Try disabling display scaling on high DPI settings by following the steps below:

1. Open your Office installation folder and right-click on the Office app that has poor scaling issues and select Properties.
2. Click on the Compatibility tab and put a check on Disable display scaling on high DPI settings.
3. Launch that Office app and see if the issue still occurs.

Effects of disabling hardware acceleration With hardware acceleration disabled, AirSpace device renders using software rendering (WARP) that relies mainly on the CPU and uses limited or no graphics card resources. You can cause a lower frame rate and increase in the working set. Performance becomes more dependent on CPU characteristics, like memory, number of cores, and on how many apps are open, and can strain the CPU resources. On Windows 7, Office animations are disabled. On Windows 8, animations are enabled because of D2D WARP improvements found in Windows 8.

http://support.microsoft.com/kb/2813143 Problem with video file dlumd32.dll versions lower than 8.7.x. I did fix this issue though. I check my graphics chip settings, and at some point, Word, OneNote and Outlook got changed to High Performance while the other programs in the suite were set to something else (I don’t remember what the setting was now, but it was clear that the offending programs had matching settings while the behaving programs matched each other). I changed the graphics settings to match the behaving programs, and now everything works just fine. I hope this helps anyone else out there that might be having the same strange problem. Changed Outlook from ‘High Performance’ to ‘Power Saving’ in the Catalyst Control Center and it worked for me. • If you use Avast Antivirus version 10.3.2225, • upgrade to Windows 10, • your Office apps may crash when you try to open them. • install their R4 release here, which resolves the issue in most cases.

Good luck.