Office Outlook / Excel Interop calls breaking (solved)

 

Background: I had a client who was using Office 2010, but after deploying Lync 2013 standalone into their environment, various Office related issues kept cropping up. It turns out that when any standalone office product is installed, it created the interoperability calls for the rest of the suite. This would lead to Office trying to pass actions from one application (Word to Outlook for example) using incorrect paths.

This was identified when a user was using the built in Send Worksheet function and was receiving errors. She could use the send workbook fine, it only cropped up when trying to send the current active worksheet. This error seems to be present in all builds (verified on my machine as well).

image003

image004

Steps to replicate

1.       Add the “Send to Mail Recipient” command to the toolbar

2.       Click on “Send to Mail Recipient” Selecting “Send the current sheet as the message body”

Deleting the following key seems to solve the issue as long as the correct Outlook 2010 (Version 14.0) key is left intact:

I couldn’t find this fix documented anywhere but lots of people have the issue with no resolution. It may not be the best approach, but it works.

The below Office 2013 registry keys that should be removed for optimal InterOp call compatibility if only Lync 2013 is installed:

 

 

Excel

HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.8

 

Word

HKEY_CLASSES_ROOT\TypeLib\{00020905-0000-0000-C000-000000000046}\8.6

 

Outlook

HKEY_CLASSES_ROOT\TypeLib\{00062FFF-0000-0000-C000-000000000046}\9.5

 

PowerPoint

HKEY_CLASSES_ROOT\TypeLib\{91493440-5A91-11CF-8700-00AA0060263B}\2.b

 

If conflicts crop up elsewhere, the following should be considered for removal:

Object Library

HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.7

 

Office Graph

HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.8

 

Active X Data Objects

HKEY_CLASSES_ROOT\TypeLib\{B691E011-1797-432E-907A-4D8C69339129}\6.1

 

WECAPI

HKEY_CLASSES_ROOT\TypeLib\{B8812619-BDB3-11D0-B19E-00A0C91E29D8}\5.5

 

Outlook View Control

HKEY_CLASSES_ROOT\TypeLib\{0006F062-0000-0000-C000-000000000046}\1.1

 

OneNote

HKEY_CLASSES_ROOT\TypeLib\{0EA692EE-BB50-4E3C-AEF0-356D91732725}\1.0

 

Project

HKEY_CLASSES_ROOT\TypeLib\{A7107640-94DF-1068-855E-00DD01075445}\4.7

 

InfoPath

HKEY_CLASSES_ROOT\TypeLib\{FD34A380-115F-43CA-8D6F-BBD45FD6F828}\4.0