Please fix an issue with Excel formatting in the Click to Run edition (Excel 2016)
We have a good number of users with a frustrating formatting issue. This occurs with the Click to Run version of Excel 2016 with documents saved in SharePoint 2013, SharePoint Online or OneDrive.
If the user formats a cell with different text formats (color, font, italic, etc.) and then later changes the formatting of a part of a cell to something different, the formatting "breaks" when the open the document again from SharePoint. Some portions of the cell are formatting correctly, while other revert to a default format and others just lose one part of the formatting (say the text was italic and blue - it might now only be blue). If the user makes any change to the document and saves it, the formatting is now saved incorrectly.
I have attached a picture of the same formatting - one is if the file is saved on the desktop and opened in C2R Excel 2016. The second is the same file saved to SharePoint 2013 and opened in C2R Excel.
This is very frustrating for the users as they spend a lot of time formatting the document and then the formats all get changed on them.
I have tested version 8528.2139 released October 16, 2017. This update fixes the issue for locally stored files. Files stored in SharePoint or SharePoint online still have the issue.
This issue has expanded to affect now all files whether stored locally or in SharePoint or OneDrive.
I have a user on build 8431.2079 (September 18, 2017) that just told me she now has the issue occurring in documents stored on her local C drive. This was not the case prior to the September release. She had worked on these documents just fine locally in August and early September. She just went back to them and is having the issue with these local documents as well. I am on version 8528.2136 and I can replicate the issue also on my local drive also.
I did some testing with and found that the issue first appeared in version 1704, build 8067.2115. Thanks Michael Burke for the instructions on rolling back - those were spot on.
Based on when we first saw the issue, I think we would have to revert to build number 1704 or earlier. We have had this issue since May.
Michael Burke commented
I suspect it's related to the latest (1708) build - https://support.office.com/en-us/article/Version-and-build-numbers-of-update-channel-releases-ae942449-1fca-4484-898b-a933ea23def7?ui=en-US&rs=en-US&ad=US#bkmk_byversion
Here are the steps on how to disable automatic updating and rollback Office.
Disable Office updating by opening any Office program and clicking File > Account, then clicking "Update Options" and then "Disable updates."
Open up the command prompt as an administrator
Paste in "cd %programfiles%\Common Files\Microsoft Shared\ClickToRun" and hit enter
Paste in "officec2rclient.exe /update user updatetoversion=16.0.8326.2107" and hit enter. This should start the rollback process.