After you have installed the SAS Add-In for Microsoft Office, the SAS^® menu might not be available or an error might occur when you open Microsoft Office. These problems typically do not occur when the SAS Add-In for Microsoft is installed and used by the same account that performed the installation. However, at least one exception does occur with the installer account. This exception is described in SAS note 43294 "The SAS OlapViewer Add-In 4.3 for Microsoft Office is not selected in the Microsoft Excel Com Add-Ins dialog box." SAS Note 43294 tells you how to correct the errors with both the installer account and subsequent user accounts by copying the Office12Interop files to the appropriate assembly directory.

The problem with multiple user accounts might occur if a previous release of the SAS Add-In for Microsoft Office has been installed and was used by multiple user accounts on the same machine. When a user that has used the previous add-in release opens Microsoft Office after installing a later release of the add-in, one of several symptoms might occur.

Symptoms

1. When you open Microsoft Excel, an Installing Office customization error might appear for the SAS OLAP Viewer occurs when you open Microsoft Excel:

   

   Note that this might be a two-part symptom. Once you have performed the steps for the workaround that is described later, the second part of this symptom occurs with a similar error but contains a slightly different path in the error. Follow the instructions in SAS Note 43294 to copy the Office12Interop files to the appropriate assembly directory to correct this issue.

   Important: The secondary part of the symptom should not occur if the installer account has already followed the steps in SAS Note 43294.

2. When you open other Microsoft Office products, such as Word or PowerPoint (and including Excel), there is no SAS menu. Here is an example of the problem in Microsoft Excel.

   

3. When you examine the COM add-ins, they appear similar to the following displays. This is an example in Microsoft Excel. The following section explains how to access the Com Add-Ins.
   Note: In the next three displays, the example paths could vary depending on the release of the SAS Add-In for Microsoft Office.

   
   The location path in this example for the SAS Add-In for Microsoft Loader is usually the correct path.

   

   
   The top-level location path in this example for the SAS Add-In 4.3 for Microsoft Office differs from the path of the SAS Add-In for Microsoft Loader. It should be the same top-level path.

   

   
   The top-level location path in this example for the SAS OlapViewer Add-In 4.3 for Microsoft Office differs from the path of the SAS Add-In for Microsoft Loader. It should be the same top-level path.

   

   
   

4. The following error might occur when you open Microsoft Office:

   

   
   

The Workaround

To correct the issues, it is necessary to remove certain SAS Add-In for Microsoft Office registry entries that exist from a previous installation for each affected user.

1. Close any open Microsoft Office applications.
2. Download and run the CleanAmoHkcu.bat file.
3. Select Run when you are prompted to run or save the file.
4. Open Microsoft Office. For example, open Microsoft Excel. The SAS menu should appear.
5. If you are using the SAS Add-In for Microsoft Office in Outlook, you must close Outlook, run SwitcherUtility.exe, make the selection for Outlook, and then open Outlook. SwitcherUtility.exe is located in the install path of the SAS Add-In for Microsoft Office.

Note: Your user account might not allow registry permissions and you might need to seek an administrator at you site to perform the registry deletions. You need to perform the preceding steps for each user account that is affected in order to correct the problem.

Accessing the COM Add-Ins

For Microsoft Excel 2007:

1. Click Office and then select Excel Options.
2. In the Excel Options dialog box, select Add-Ins.
3. Ensure that COM Add-Ins is selected in the Manage list and click Go.
4. Select SAS OlapViewer Add-In 4.3 for Microsoft Office and then click OK.

For Microsoft Excel 2010:

1. Select File ► Options from the menu.
2. In the Excel Options dialog box, select Add-Ins.
3. Ensure that COM Add-Ins is selected in the Manage list and click Go.
4. Select SAS OlapViewer Add-In 4.3 for Microsoft Office and then OK.

The issues that are described in this SAS note are planned to be fixed in a future release of the SAS Add-In for Microsoft Office.

Caution: Always back up your registry before you make any changes to it. Changes to the Microsoft Windows registry can render your system unusable and require that you re-install your operating system. SAS is not responsible when you edit the Windows registry. For more information about backing up your registry, see the Windows Help or the Microsoft Web site.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 4.3 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 4.305 on SAS 9.3 is available at: