Problem Note 41171: The SAS® Add-In 4.3 for Microsoft Office does not display the SAS® menu in Microsoft Office 2003 programs
The SAS Add-In 4.3 for Microsoft Office does not display the SAS menu in Microsoft Office 2003 programs that are running in a Windows 7 x64 operating environment. This issue also might occur in other Windows x64 operating environments, such as Windows Server 2008 R2.
The problem occurs because of the way that the Wow6432Node registry entry, Microsoft Office 2003, and the SAS Add-In 4.3 for Microsoft Office work together. The Microsoft Office program opens, but the SAS menu does not display in the program.
The issue can be resolved by first applying the hot fix and subsequently using the reg file from the Downloads tab to correct the registry. Here are the steps to take.
- Use the Hot Fix tab to download and apply the appropriate hot fix.
- Use the Downloads tab to download the SN41171.reg file, and run the file to import the registry settings.
The registry import needs to be done for each user who has already tried using Office and does not have a SAS menu.
- Open a Microsoft Office program.
The SAS menu should display in the program.
If the SAS menu still does not appear, then you need to add the COM Add-ins menu and select SAS. To add the COM Add-ins menu, perform the following steps:
Note: The following steps can also be performed in Word and PowerPoint.
- Open Excel and select Tools ► Customize.
The Customize dialog box appears.
- Click the Commands tab.
- Under Categories, select Tools, and then under Commands, locate and drag COM Add-ins to the program's menu bar.
- Close the dialog box.
- Select COM Add-ins.
- In the COM Add-ins dialog box, select the SAS check box if it is not selected, and then click OK.
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 reinstall your operating system. SAS is not responsible when you edit the Windows registry. For more information about backing up your registry, see Windows Help or the Microsoft Web site.
Operating System and Release Information
SAS System | SAS Add-in for Microsoft Office | Microsoft Windows Server 2008 for x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 |
Windows Vista for x64 | 4.3 | | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 |
Windows 7 Professional x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 |
Windows 7 Ultimate x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The SAS menu might not display in Office 2003 on x64 machines.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2010-10-18 09:09:10 |
Date Created: | 2010-10-07 16:38:04 |