When you open a Microsoft Office program on a computer that has the SAS Add-In 4.3 for Microsoft Office and the SAS Add-In 4.2 for Microsoft Office installed side-by-side, the following error message might appear:

Although the error message states that the issue might be due to an incorrect version of .Net Framework being loaded, the problem is not related to .Net Framework. You do not need to remove or reinstall .Net Framework.

The problem occurs because both the SAS Add-In 4.3 for Microsoft Office and the SAS Add-In 4.2 for Microsoft Office attempt to load when you open a Microsoft Office program in this instance. If you click OK in the error message, the Microsoft Office program opens and the SAS Add-In 4.3 for Microsoft Office works correctly for that session.

Note: The account that performed the SAS Add-In 4.3 for Microsoft Office upgrade does not receive this error. Only subsequent users other than the installer account are affected.

Hot Fix

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

This hot fix relies on a patched version of the Visual C run-time components that fix a security gap in the Active Template Library (ATL). To fix this problem, select the Downloads tab in this note.

For more information about the Active Template Library (ATL) update, see SAS Note 40703, "SAS menu may disappear or become unresponsive in Microsoft Office after applying A54008 hot fix"

Workarounds

If you do not apply the hot fix, you can follow one of these workarounds to resolve this issue so that the error message does not appear:

Remove the SAS^® Add-In 4.2 for Microsoft Office

Remove the SAS Add-In 4.2 for Microsoft Office. You can remove the SAS Add-In 4.2 for Microsoft Office either before or after you install the SAS Add-In 4.3 for Microsoft Office.

Clear the SAS Check Box in the COM Add-Ins Dialog Box

Use the COM Add-Ins dialog box to clear the SAS check box:

The following examples provide the steps to clear the SAS check box in the COM Add-Ins dialog box in Microsoft Excel, but these steps also work in other Office programs.

In Excel 2003:

1. Select Tools ► Customize.
2. Click the Commands tab.
3. Under Categories, select Tools.
4. Under Commands, locate and drag COM Add-ins to the menu bar.
5. Close the Tools dialog box.
6. Select COM Add-ins on the menu bar.
7. In the COM Add-Ins dialog box that appears, clear the SAS check box, and then click OK.

In Excel 2007:

1. Click the Microsoft Office button.
2. Click Excel Options.
3. In the left-hand panel, select Add-Ins.
4. In the Manage drop-down menu, select COM Add-ins, and then click Go.
5. In the COM Add-Ins dialog box that appears, clear the SAS check box, and then click OK.

In Excel 2010:

1. Select File ► Options.
2. Select Add-Ins.
3. In the Manage drop-down menu, select COM Add-ins, and then click Go.
4. In the COM Add-Ins dialog box that appears, clear the SAS check box, and then click OK.

Run the Switcher Utility

If you have administrator privileges, then you can run the Switcher Utility to switch to the SAS Add-In 4.2 for Microsoft Office and back to the SAS Add-In 4.3 for Microsoft Office. The Switcher Utility does affect other accounts than the administrator that might use the computer that has the SAS Add-In for Microsoft Office installed. To run the Switcher Utility:

1. Close all Office programs.
2. Run SwitcherUtility.exe by navigating to C:\Program Files\SAS\Add-InForMicrosoftOffice\4.3.
3. To switch between the releases of the SAS Add-In for Microsoft Office:
• If the SAS Add-In 4.3 for Microsoft Office is selected, then select the SAS Add-In 4.2 for Microsoft Office. Click OK.
• If the SAS Add-In 4.2 for Microsoft Office is selected, then select the SAS Add-In 4.3 for Microsoft Office. Click OK.
4. Run SwitcherUtility.exe again and select the SAS Add-In for Microsoft Office that you want active.
5. Click OK.
6. Open an Office program, and the error message does not appear.

Note: If an administrator account uses the Switcher Utility to switch to the SAS Add-In 4.2 for Microsoft Office, other users might experience two SAS menus on the menu bar when they open an Office program:

The hot fix resolves this issue. However, if the hot fix above is not applied, either remove the SAS Add-In 4.2 for Microsoft Office or clear the SAS check box in the COM Add-Ins dialog box, as described in the "Workarounds" section above, to resolve this issue.

Microsoft Excel 2010 Does Not Open

When both the SAS Add-In 4.3 for Microsoft Office and the SAS Add-In 4.2 for Microsoft Office are installed side by side, the splash page for Excel 2010 appears and remains visible when you try to open the program. However, the program does not open.

This issue occurs because the Unable to load error message is open behind the splash page.

If you minimize the splash page, then the error message appears. If you click OK in the error message, then Excel 2010 opens, and the SAS Add-In 4.3 for Microsoft Office is active and works appropriately for that session.

If you close the splash page by clicking Cancel or clicking the X on the splash page, then the error message behind the splash page also closes. When you open Excel 2010 again, the following error message then appears:

If this error message appears, then click No so that the SAS Add-In for Microsoft Office is not disabled.

Note: If you are not sure of the add-in release that is installed on your machine, then See SAS Note 41524 "How to determine the release of the SAS Add-In for Microsoft Office" for more information about determining the add-in release.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Add-in for Microsoft Office	Windows 7 Enterprise x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Enterprise 32 bit	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows XP Professional	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2008 for x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2008	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2003 for x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2003 Standard Edition	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2003 Enterprise Edition	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft Windows Server 2003 Datacenter Edition	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Microsoft® Windows® for x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Home Premium 32 bit	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Home Premium x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Professional 32 bit	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Professional x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Ultimate 32 bit	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows 7 Ultimate x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows Vista	4.22	5.1	9.2 TS2M2	9.3 TS1M1
		Windows Vista for x64	4.22	5.1	9.2 TS2M2	9.3 TS1M1

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

---

Hot Fix A54008 or later relies on a patched version of the Visual C run-time components that fix a security hole in the Active Template Library (ATL).

Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update

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

http://ftp.sas.com/techsup/download/hotfix/HF2/A54.html#40584

---

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

http://ftp.sas.com/techsup/download/hotfix/HF2/C46.html#40584

---

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

http://ftp.sas.com/techsup/download/hotfix/HF2/D19.html#40584

---

When the SAS® Add-In 4.3 for Microsoft Office and the SAS® Add-In 4.2 for Microsoft Office are installed side-by-side and you open a Microsoft Office program, an "Unable to load the SAS Add-In for Microsoft Office" error displays. For Excel 2010 in this instance, the program does not open.

Type:	Installation Note
Priority:	high

Date Modified:	2010-08-27 16:16:36
Date Created:	2010-08-12 17:11:33