If you are using SAS^® Add-In for Microsoft Office to display a SAS Visual Analytics report in a Microsoft Office document (Excel, PowerPoint, or Word), you might encounter this issue if your report contains gauge report objects.

For example, you might replicate this issue by performing the following steps:

1. Create a SAS Visual Analytics report that contains two pages.
2. Add four gauges report objects (Dial) to Page 1.
3. Add a list table to Page 2.
4. Add a drop-down list as a report control and choose a category data item as a role.
5. Open Microsoft Excel and add this report to the document,
6. Click the filter icon in the SAS panel ► Results tab to enable the drop-down list.
7. Select a data item from the drop-down list. All report objects (gauges and list table) are successfully updated and filtered. The following image shows the Excel sheet that contains four gauge report objects filtered by a specific data item (Front) from the drop-down list.

8. Change the filter value (for example, from Front to All in the drop-down list) and switch from Page 1 to Page 2 in the SAS panel ► Results tab. Then, report objects are correctly filtered by All. However, gauge report objects are not displayed anymore in the Excel sheet. The following image shows the problem:

To work around this problem, click the Refresh icon in the SAS panel.

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 Visual Analytics Add-In for Office 8.3 is available at: