Office365 Office 2016 Version 1708 (Build 8431.2079) update breaks cell highlighting in Excel

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.


Office365 Office 2016 Version 1702 (Build 7870.2024) update breaks Outlook search

Edit: As of 27/03/2017 Microsoft has released Build 7870.2031 of Office 2016 which appears to have fixed the issue. It has for me anyway.

Recently Office 2016 updated itself (Office365 subscription so it uses ClicktoRun) to version 1702 (Build 7870.2024) and this appeared to break searching emails in Outlook 2016.

I thought that maybe the index was corrupt, so I tried triggering a rebuild, but this did not resolve the issue.

To see what version you’re running, have a look in the Account section of a programme in the Office Suite. For example, in Excel open a blank workbook, then click on File on the ribbon, and choose Account in the list on the left-hand side:

There you can see it lists info about the current version, in this case Version 1702 (Build 7870.2024), and lets you alter update options.

As a temporary workaround I disabled automatic updates, and then rolled back to a previous version.

To disable updates, click on Update Options > Disable Updates. I’m in Windows 7, and I got a UAC prompt to confirm the action.

Click on Update Options > View Updates to get to the version history web page. This page shows what’s changed through the different versions. Scroll down near the bottom and you’ll see a Previous Releases section where you can look at the different versions released in previous months.

I decided to try going back just one version, which is listed as Version 1701 (Build 7766.2060).

In order to roll back to a previous version, open a command prompt, enter cd “%programfiles%\common files\microsoft shared\clicktorun” and hit return.

Now you can run the ClicktoRun client and tell it to update to a specific version (using the build number we found above; 7766.2060).

Type in OfficeC2RClient.exe /update user updatetoversion=16.0.7766.2060 and hit return. There won’t be any output in the command line to look at, you’ll just be taken back to the prompt:

Very soon, if not immediately, you should see something like this showing that updates are being downloaded:

Once it’s done, open Outlook and try a search. To start with I got a warning about the index not being complete, so I guess it triggered a rebuild.

In Windows 7 the indexing process slows down when it detects someone is using the computer but you can disable this if you find it is taking a long time to rebuild.