41171 - The SAS® Add-In 4.3 for Microsoft Office does not display the SAS® menu in Microsoft Office 2003 programs

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

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
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.

Type:	Problem Note
Priority:	medium

Date Modified:	2010-10-18 09:09:10
Date Created:	2010-10-07 16:38:04

Support

Problem Note 41171: The SAS® Add-In 4.3 for Microsoft Office does not display the SAS® menu in Microsoft Office 2003 programs

Operating System and Release Information