Recently Office 2016 updated itself (Office365 subscription so it uses ClicktoRun) to version 1708 (Build 8431.2079) and this appeared to break cell highlighting in Excel worksheets that have headers and footers. Cells that you highlight turn black. Scrolling down and back up to hide/reveal the cells removes the black fill and doesn’t show the actual colour.
It turns out Microsoft are aware of the issue and a fix has been released as Version 1708 (Build 8431.2094). The advice on the page is to manually force it to update.
However, that does not work for me and it simply reports that the latest version is already installed. When looking at the installed version number in Excel there is a line that says “Monthly Channel” so maybe I’m supposed to wait for the update to be released to me?
I decided to disable updates and see if I could force a manual update to the new version from the command line. This did not work, it reported that the latest version of Office approved by your system admin (whoever that is?) is installed on your computer.
So I was left with no choice but to roll back to a previous version.
I opened a command prompt and changed directory to C:\Program Files\Common Files\Microsoft Shared\ClickToRun
I ran the following command: OfficeC2RClient.exe /update user updatetoversion=16.0.8326.2058
Thanks for not properly testing your updates before releasing them, Microsoft.