In SAS Add-In for Microsoft Office, you might encounter the following error when refreshing SAS Visual Analytics reports:

This error typically occurs after you update the data sources for the report that you are refreshing, and you do not save the report in the SAS Visual Analytics application after the data update.

For example, you might encounter this issue if you complete steps similar to the following:

1. Upload your data source to the LASR Server.
2. Create a new report with a bar chart and select Name as the category role and Sex as the group role:

3. Save the report in SAS Visual Analytics.
4. Add the report in SAS Add-In for Microsoft Office and save the file.

5. Modify the data source and apply a filter to it so that your data source now contains only SEX=M.
6. Upload the new data source to the LASR Server and replace the old one. In SAS Report Viewer, the report displays correctly. The bar chart shows only SEX=M:

8. Open the Excel file that you saved previously and click Refresh. The following error occurs:

To work around this issue, use the Reset option from the overflow menu in the report pane in SAS Add-In for Microsoft Office instead of the Refresh option.

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

Operating System and Release Information

A fix for this issue for SAS Add-In for Microsoft Office 8.3 is available at:

A fix for this issue for SAS Add-In for Microsoft Office for Visual Analytics 8.3 is available at:

A fix for this issue for SAS Visual Analytics Add-In for Office 8.3 is available at: