Problem Note 40703: SAS menu may disappear or become unresponsive in Microsoft Office after applying A54008 hot fix
The SAS menu may disappear in Microsoft Office 2007 or become unresponsive in Microsoft Office 2003 after applying Hot Fix A54008 for the SAS® Add-in for Microsoft Office 4.2. This can happen if you apply this hot fix to a machine that does not contain the patched version of the Visual C run-time components that fix a security hole in the Active Template Library (ATL). Without this patch, our COM Add-in does not load properly.
To fix this problem, download the Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update from the Microsoft Web Site. You can click the Downloads tab to find a link to the patch.
After you apply the security patch from Microsoft, you will have to reload the SAS® Add-in in order for the SAS menu to redisplay. You can do this one of two ways.
The first option is to use the SwitcherUtility to reload the SAS menu on all the Microsoft Office applications. To do this, follow these steps:
- Open a Windows explorer window.
- Navigate to the installation directory of the SAS® Add-in for Microsoft Office. By default, this location is installed in c:\Program Files\SAS\Add-inForMicrosoftOffice\4.2\.
- Double click the SwitcherUtility.exe file in this folder.
- When the window opens make sure you have the installation of 4.2 selected, as well as all the Office products selected to be enabled. (See below)
The second option is to manually reload the SAS® Add-in using in the Com Add-ins window. You can use the following steps to do this:
For Office 2003:
- Select Tools → Customize.
- Click the Commands tab.
- Under Categories, select Tools
- Under Commands, locate and drag COM Add-Ins to the menu bar
- Close the Tools dialog box.
- Select COM Add-Ins on the menu bar
- In the COM Add-Ins dialog box that appears, select the SAS check box, and then click OK.
For Office 2007:
- Select the Microsoft Office button.
- Select the Options button at the bottom of the window for whichever Office product you are running.
- In the left-hand panel, select Add-Ins.
- In the Manage drop-down menu at the bottom of the window, select COM Add-ins and then click Go.
- In the COM Add-Ins dialog box that displays, select the SAS and the SAS Add-In for Microsoft Office Loader checkboxes, and then click OK.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Standard Edition | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 for x64 | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2008 | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2008 for x64 | 4.22 | | 9.2 TS2M2 | |
| Microsoft Windows XP Professional | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Enterprise 32 bit | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Enterprise x64 | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Home Premium 32 bit | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Home Premium x64 | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Professional 32 bit | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Professional x64 | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Ultimate 32 bit | 4.22 | | 9.2 TS2M2 | |
| Windows 7 Ultimate x64 | 4.22 | | 9.2 TS2M2 | |
| Windows Vista | 4.22 | | 9.2 TS2M2 | |
| Windows Vista for x64 | 4.22 | | 9.2 TS2M2 | |
*
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: | high |
| Date Modified: | 2010-08-27 14:35:33 |
| Date Created: | 2010-08-26 14:54:49 |
