SAS Add-In for Microsoft Office 4.2 has a configuration option that prevents the Add-In from loading when a Microsoft Excel spreadsheet is embedded in another Microsoft Office application such as Word. To avoid this error, perform these steps:

1. Close all Microsoft Office applications on the client machine.
2. Create a file named SAS.OfficeAddin.dll.config and place it in the following location on the client machine:

   <drive>:\Program Files\SAS\Add-InForMicrosoftOffice\4.2

   Note: This instruction assumes the Add-In was installed in the default location. If you didn't install the application in the default location, place the configuration file in the directory where you installed the Add-In.

3. Edit SAS.OfficeAddin.dll.config and add the following lines:

<configuration>
    <assemblySettings> 
        <add key="LoadWhenEmbedded" value="false"/>
    </assemblySettings> 
</configuration> 

4. Save the file.

Operating System and Release Information