When you invoke Crystal Xcelsius software, a SAS Add-in for Microsoft Office error message might appear:

Unexpected exception occurred in SAS Add-In For Microsoft Office. 
Please report this error to your site administrator.

Note: Crystal Xcelsius works with Excel.exe in the background. The details of the error are as follows:

System.NullReferenceException: Object reference not set to an instance 
of an object.at SAS.OfficeAddin.CommandBarManager.InstallUI()

An additional error might appear:

System.Runtime.InteropServices.InvalidComObjectException: COM object 
that has been separated from its underlying RCW cannot be used.

To correct the behavior, follow these steps to direct SAS Add-in for Microsoft Office to not load if it is embedded when another application uses Excel:

1. Using a text editor, such as Notepad, type the following:
   <configuration> <assemblySettings> <add key="LoadWhenEmbedded" value="false"/> </assemblySettings> </configuration>
   
   
   
2. Save the file as SAS.OfficeAddin.dll.config, where SAS Add-in for Microsoft Office is installed, which by default is in C:\Program Files\SAS\Add-In for Microsoft Office.

Important: Do not confuse the SAS.OfficeAddin.dll.config file with the SAS.OfficeAddin.dll file. Do not edit or modify the SAS.OfficeAddin.dll file.

Operating System and Release Information