After you install the SAS Add-In for Microsoft Office, the SAS menu or the add-in toolbars might be missing from Microsoft Excel, Microsoft Word, or other Microsoft Office applications. The problem shows up in different ways:

• The SAS menu or toolbars are present in Word but not in Excel, or vice versa.
• The SAS menu or toolbars are missing for one user account, but they are present for other user accounts.

To troubleshoot this problem, use the following instructions to examine both the Disabled Items and the Common Object Model (COM) Add-Ins. Follow the steps for your version of Microsoft Office.

Note: These instructions use Microsoft Excel in multiple versions of Microsoft Office. However, you can use the instructions for other Microsoft Office products. Simply substitute the other product name in the instructions. For example, use Word in place of Excel.

 

Check Disabled Items

For Office 2003

1. Open Microsoft Excel.
2. Select Help ► About Microsoft Excel.
3. Click the Disabled Items button.
4. Select SAS and click the Enable button.
5. Restart Excel.

 

For Office 2007

1. Open Microsoft Excel.
2. Click the Office button in the top left corner of the Excel window.
3. Click Excel Options and then click Add-Ins in the left navigation pane.
4. In the Manage drop-down list at the bottom, select Disabled Items and then click Go.
5. Select SAS and click the Enable button.

 

For Office 2010, Office 2013, and Office 2016

1. Open Microsoft Excel.
2. In the top left corner of the Excel window, select File ► Options. The Excel Options dialog box appears.
3. Click Add-Ins in the left navigation pane.
4. In the Manage drop-down list at the bottom, select Disabled Items and then click Go.
5. Select SAS and click the Enable button.

 

Check the COM Add-Ins

For Office 2003

1. Open Microsoft Excel.
2. Select Tools ► Customize.
3. Click the Commands tab.
4. Under Categories, select Tools.
5. Under Commands, locate and drag COM Add-ins to the menu bar.
6. Close the Tools dialog box.
7. Select COM Add-ins on the menu bar.
8. In the COM Add-Ins dialog box that appears, select the SAS check box (if it is not already selected) and then click OK.

 

For Office 2007

1. Open Microsoft Excel.
2. Click the Microsoft Office button.
3. Click Excel Options.
4. In the left-hand panel, select Add-Ins.
5. In the Manage drop-down menu, select COM Add-Ins, and then click Go.
6. In the COM Add-Ins dialog box that appears, select the SAS check box (if it is not already selected) and then click OK.

 

For Office 2010, Office 2013, and Office 2016

1. Open Microsoft Excel.
2. Select File ► Options.
3. Select Add-Ins.
4. In the Manage drop-down menu, select COM Add-Ins, and then click Go.
5. In the COM Add-Ins dialog box that appears, select the SAS check box (if it is not already selected) and then click OK.