SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsDownloadsHotfixAboutRate It

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.

  1. Use the Hot Fix tab to download and apply the appropriate hot fix.
  2. 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.

  3. 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.

  1. Open Excel and select Tools ► Customize.

    The Customize dialog box appears.

  2. Click the Commands tab.
  3. Under Categories, select Tools, and then under Commands, locate and drag COM Add-ins to the program's menu bar.
  4. Close the dialog box.
  5. Select COM Add-ins.
  6. 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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Add-in for Microsoft OfficeMicrosoft Windows Server 2008 for x644.34.3059.2 TS2M39.2 TS2M3
Windows Vista for x644.39.2 TS2M3
Windows 7 Enterprise x644.34.3059.2 TS2M39.2 TS2M3
Windows 7 Professional x644.34.3059.2 TS2M39.2 TS2M3
Windows 7 Ultimate x644.34.3059.2 TS2M39.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.