The latest Microsoft Office 2016 updates might prevent SAS Add-In for Microsoft Office from creating new PivotTables in Microsoft Excel. Specifically, this issue can occur if you have Microsoft Office build 9126.2259 or later.

When this problem exists, the following error might appear when you open data into a PivotTable:

If you click Abort, you can create the PivotTable. However, the PivotTable is not SAS content and cannot be refreshed.

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.0 is available at:

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

A fix for this issue for SAS Add-in for Microsoft Office 7.15 is available at:

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