When installed from the Microsoft Office 365 suite, SAS Add-In 5.1 for Microsoft Office initially does not function correctly.

Note: When SAS Add-In 5.1 for Microsoft Office is installed from standard Microsoft Office 2013, the issues discussed in this installation note do not occur.

Symptom 1: No SAS Menu, and Microsoft Office Not Listed under COM Add-Ins

After the SAS Add-In installation is performed and you have opened an Office application (for example, Excel 2013), there is no SAS menu. Also, if you examine the COM Add-Ins dialog box, SAS Add-In 5.1 for Microsoft Office is not present.

1. Open Microsoft Excel 2013.
2. Select File ► Options.
3. Select Add-Ins.
4. Select Manage ► COM Add-Ins and then click Go.
5. In the COM Add-Ins dialog box that appears, SAS Add-In 5.1 for Microsoft Office is not present.
   

Symptom 2: Initialization Error Occurs

If you run the Switcher Utility in an attempt to correct the missing SAS menu, the following error occurs:

Here is an example of a path to the SwitcherUtility.exe file:

How to Determine Which Version of Office 2013 Is Installed

1. Open Microsoft Excel 2013, click File and then Account.
2. Click About Excel.
3. The About Microsoft Excel dialog box appears, showing the Office version.

Examples

• This screen shot shows the About Microsoft Excel dialog box for Office 2013 as installed from a standard Office 2013 installation.





• This screen shot shows the About Microsoft Excel dialog box for Office 2013 installed from Office 365.

If your version of Office is installed from Office 365, contact SAS Technical Support here and mention this SAS Note.

Update: The behavior described in this SAS note has also been known to occur with Microsoft Office Home and Business 2013 edition.

• This screen shot shows the About Microsoft Excel dialog box for Office 2013 installed from Microsoft Office Home and Business 2013 edition.

Operating System and Release Information