Installing Office 2013

Today I finally got round to installing Office 2013 Pro Plus (x86), Visual Studio 2012 Ultimate and SQL Server 2012 Enterprise Edition (x86). The order I installed them in is as listed because in the past I’ve found that installing Visual Studio before Office led to problems.

Since I’d been participating in the Office 2013 beta testing, the first thing I had to do was uninstall the Office 2013 preview version from my machine. This was easy enough: I just followed the instructions on this Microsoft Support article. On the article there’s a special mention the ‘Fix it’ download should be run first when uninstalling a Preview version.

Once the Preview uninstall was done, I was just left with Office 2010 on my computer. I really like Excel 2010, so I decided to keep it when I installed Office 2013. To do this, I chose a custom installation type when prompted:

CustomInstall

And then, on the Upgrade tab I chose to remove all Office applications except for Microsoft Office Excel:

UpgradeOptions

Of course, if you want to keep all previous versions then you should choose the ‘Keep all previous versions’ option. My machine is x86 so I wasn’t given a choice between x86 and x64-bit Office.

Once I’d clicked on the Upgrade button the installation took just over 20 minutes, which isn’t too bad. At the end of the installation I rebooted my machine and then launched Excel 2013. When it loaded I was met with these error messages:

Custom UI Runtime Error in Chinese Translation Addin: The call to GetCustomUI() for RibbonID “Microsoft.Excel.Workbook” failed.

Custom UI Runtime Error in Visual Studio Tools for Office Design-Time Adaptor for Excel: The call to GetCustomUI() for RibbonID “Microsoft.Excel.Workbook” failed.

Ugh. I was disappointed when I saw these because I’d reported them during the beta testing and I’d had interactive conversations with Microsoft about them, so I’d genuinely expected them to be fixed. I’ll explain how to get rid of them in a minute, but first let’s finish the installation process.

I clicked OK through the error messages and then I was prompted to activate Office. I chose the ‘enter a product key’ option, entered the key, clicked on install, watched a short animation, chose ‘No Background’ (this can be customised later) and then it was finally done!

Now it was time to get rid of those pesky GetCustomUI() errors. From within the Excel ‘Start screen’ I pressed CTRL+N to open a new workbook and then I went to the DEVELOPER tab, clicked on the COM Add-Ins button and then un-ticked the ‘Chinese Translation Addin’ and ‘Visual Studio Tools for Office Design-Time Adaptor for Excel’ add-ins.

COMAddins

I then closed and re-opened Excel to make sure everything was okay, which it was.

At this point I remembered that these add-ins had reared their ugly heads again during the Office Preview testing when I’d installed an update, so I decided to fix them once and for all.

To completely remove the Chinese Translation AddIn from my computer, I went to Control Panel\All Control Panel Items\Programs and Features and uninstalled the Microsoft Office Proofing Tools Kit 2007. I’d never used it anyway.

To fix the VSTO Design-Time Adaptor for Excel add-in, first of all I continued with my planned installation of Visual Studio 2012, then I downloaded the Microsoft Office Developer Tools for Visual Studio 2012. This version of the add-in works absolutely fine in Excel 2013.

COMAddinsVSTO2012

With those errors sorted, it was time for the finishing touches.

I checked the VBA IDE and I was pleased to find that it had inherited my custom settings from 2010, so nothing to do there.

I’m not a fan of the ‘white-look’ Office, so the last customisation I made at this stage was the Office theme. To change the theme colour go to File > Options > General and in the ‘Personalize your copy of Microsoft Office’ you can choose between white, light gray and dark gray. I chose dark gray and I ticked the option to use it regardless of the sign in to Office. If you want to, you can also change the office background here too.

GeneralOptions

I also updated these preferences under File > Account:

AccountTheme

Job done.

In the comments, Sam asked for a screenshot of the dark gray theme, so here’s one with all three for comparison. The white and light gray themes are very similar to one another.

ThemeColours

Advertisements

About Colin Legg

RAD Developer Microsoft MVP - Excel 2009 - 2014
This entry was posted in Microsoft Excel, Microsoft Office and tagged , , , , , , , , , . Bookmark the permalink.

5 Responses to Installing Office 2013

  1. sam says:

    Please post a snap shot of how Excel Looks with the Grey Theme….The Beta look is absolutely pathetic

    Like

  2. Colin Legg says:

    Hi Sam. I’ve added a screenshot of the three themes to the end of the post now.

    Like

  3. Christina says:

    Hi!

    I bought Office 2010 Home & Student late last year including the oportunity to download Office 2013 Home & Student for free. So I did that and installed it and hade the same error as you GetCustomUI … RibbonID “Microsoft.Excel.Workbook”… The problem was solved by doing as you did, in-ticking “Visual Studio Tools for Office Design-Time Adaptor for Excel”. Thank you!

    Like

  4. Hossein A says:

    Good job. I had the same error but I had to disable another COM Add-in. The add-in was Visual Studio Tools for Office Design-Time Adapter for Excel. This was an older version (VS 10.0) of the add-in. The VS 11.0 add-in version is enabled and Excel works fine.

    Like

  5. Daniel Kam says:

    Awesome! Worked for me.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s