When you double-click values in a pivot table in Microsoft Excel with SAS Add-In for Microsoft Office installed, a Credentials Required pop-up message might appear.

This problem occurs only when you have not selected the Save login in profile option in your SAS^®9 Metadata Profile, as shown below:

1. Microsoft Excel ► SAS ► Tools ► Connections ► Edit your profile and clear the Save login in Profile check box.
2. Create a pivot table and double-click any value.

Note: The Credentials Required pop-up message appears even if you did not perform any actions related to any SAS components.

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

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