When you are using the SAS Add-In for Microsoft Office 4.2 or 4.3, the following error might occur:

Other possible errors might include the following:

It is important to note that the above errors might or might not occur as there could be other varying unexplainable symptoms. A common symptom would be a SAS menu with grayed out selections or the selections are inoperable.

This problem is most likely caused by a Microsoft patch that instructs the .Net Framework to use a version of the .Net Framework that is not compatible with the SAS Add-In for Microsoft Office 4.2 or 4.3.

This problem might also occur if there are configuration files already in place that are instructing the SAS Add-In for Microsoft Office to use a .Net Framework version that does not meet the product system requirements. In this case, the existing configuration files could be removed or they could be updated as explained in the next section.

To correct the problem, use configuration files that instruct Excel or Word to use a compatible .Net Framework version for the SAS Add-In for Microsoft Office. The configuration files, named excel_SN40066.exe.config and winword_SN40066.exe.config, are available for download from this link.

Important Information

When you download the configuration files from the link above, use .config Document or All Files in the Save as type field. You must rename these files to excel.exe.config and winword.exe.config. In your Microsoft Office installation location, place the excel.exe.config file where Excel.exe resides, and place the winword.exe.config file where Winword.exe resides. Then restart Excel or Word.

This problem occurs not only from a Microsoft patch, but from the installation of another application that is adding a registry entry. Using the configuration files as instructed in this SAS note should correct the problem.

With these configuration files in place, the problem should not occur again, even with subsequent Microsoft patches or software applications that cause the behavior.

Caveat

Consideration for using the configuration files is important with respect to future SAS Add-In for Microsoft Office releases. If a future release of the software has a baseline minimum of a .Net Framework version that is greater than the version for the SAS Add-In for Microsoft Office 4.2 or 4.3, the configuration files could cause a problem. In that case, remove the configuration files.

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 Vista	4.2		9.2 TS2M0
		Windows Vista for x64	4.2		9.2 TS2M0
		Microsoft Windows XP Professional	4.2		9.2 TS2M0
		Microsoft Windows Server 2008 for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Standard Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Datacenter Edition	4.2		9.2 TS2M0
		Microsoft® Windows® for x64	4.2		9.2 TS2M0

* 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 error, "Unable to load the SAS Add-In for Microsoft Office" might occur due to the incorrect version of the .Net Framework that is being loaded. This can occur when there is a configuration file that instructs the Microsoft Office application to use a specific version of the framework.

Type:	Usage Note
Priority:

Date Modified:	2010-06-25 16:17:43
Date Created:	2010-06-21 15:23:01