THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Issues with July 2014 Office Update and Click-to-Run #excel #powerbi

An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day at SQL Bits about how to create a complete solution in Power BI. But I think it’s important to share.

Symptoms:

  • Excel crashes when you click Save As
  • Word crashes when you click Save As
  • Outlook crashes when you click File Office Account
  • Power Point crashes when you click Save As

In a word: Office no longer works well and crashes often.

Yesterday I installed the latest update of Office using the Click-to-Run distribution: it’s not Windows Updates, so I cannot check in Windows Update what are the updates installed. You have to check the version you installed and this could be hard if the window that should show the number makes the application crashing.

However, after some investigation:

  • I took a look at the page that shows the versions released for click-to-run: http://support.microsoft.com/gp/office-2013-click-to-run
  • I had the version 15.0.4631.1002 – July 2014 update (http://support.microsoft.com/KB/2980001)
  • I wanted to revert back to the previous version (15.0.4623.1003 – June 2014 update)
  • I followed instructions described here: https://community.office365.com/en-us/f/172/t/251109.aspx
    • Open an administrative command prompt, then run one of the next two commands based on your version:
      • For an Office installation in a 32-bit version of Windows:
        cd %programfiles%\Microsoft Office 15\ClientX86
      • For an Office installation in a 64-bit version of Windows
        cd %programfiles%\Microsoft Office 15\ClientX64
    • Then run the following command:
      officec2rclient.exe /update user updatetoversion=15.0.4623.1003

I think that this procedure could be useful in the future in case any similar issue will happen again (hopefully not…)

Lessons learned: never install *any* update the day before speaking at a conference. Not only Windows Updates, but also Office Click-to-Run updates…

Published Thursday, July 17, 2014 2:11 PM by Marco Russo (SQLBI)
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jonathan Ivory - IT said:

I ran into this same issue post updates for my users.  Clean installing office without rolling update version back, also resolves this issue.  I used the cscript in cmd prompt command to remove the license and http://support.microsoft.com/kb/2739501 to uninstall office.  After reinstallation Office 2013 works fine. Hope this is helpful as well.

July 17, 2014 10:32 AM
 

Donald Parish said:

I had same problem last week using the regular Office install after July updates. Reinstall worked, but failed again after latest updates reinstalled. Trying to isolate the exact update.

July 18, 2014 9:02 AM
 

danh said:

Well done, because I was at that session and the disaster wasn't so clear to the attendees !

Serious point is that the Office 365 update model is encouraging people to "wave through" updates as per Microsoft's clear strategy, but occurrences like this and Office 2013 SP0 give nay sayers too much ammunition.

November 4, 2014 8:04 PM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement