SAS Add-In for Microsoft Office might time out while trying to open large SAS Visual Analytics reports. In the SAS Add-In logging file, connection time-out errors similar to the following appear:

The following error might appear as well:

Beginning in SAS Add-In for Microsoft Office release 8.2, a configuration option is available to override the time-out. In version 8.2, the default report time-out threshold is 25 seconds. If this threshold needs to be increased, add the ReportTimeoutThreshold configuration option to the SAS.OfficeAddIn.dll.config file. 

Edit the SAS.OfficeAddIn.dll.config file using a plain text editor. This file is located in the SAS Add-In for Microsoft Office installation directory. Add the ReportTimeoutThreshold key, making sure to match the casing exactly. For the value attribute, enter an integer greater than 25 in double quotation marks. Here is an example:

Operating System and Release Information