If you refresh SAS^® Content from the Manage Content window when a "copied" worksheet is active, you might receive the following error the next time that you try to refresh your original PivotTable:

PivotTable was not found

This error is most likely to happen after you perform the following tasks:

1. You select SAS ► SAS Data in order to create a PivotTable on a worksheet from a SAS table.
2. You right-click on the worksheet tab, select Move or Copy, check the Create a copy check box, and select where to copy the new worksheet.
3. You select the new worksheet as your active sheet.

Note: The content on this worksheet is not SAS content. It is a copied PivotTable as explained in SAS Note 44932.

4. While on the "copied" worksheet, you select SAS ► Manage Content, select the check box next to some SAS Content that you want to refresh, and click Refresh.
5. You return to the original worksheet, select a cell in the PivotTable and you try to refresh the content by selecting SAS ► Refresh. At this point, the error appears.

After the error appears, the underlying metadata for the SAS Content is corrupted. In order to refresh the SAS Content you must rebuild the original SAS Content. To avoid this problem, do not refresh SAS Content when a "copied" worksheet is active. Instead, only refresh SAS Content from the Manage Content window when a worksheet that contains original SAS Content is active.

Operating System and Release Information

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