Undo an Action in Microsoft Excel with the SAS Add-In for Microsoft Office Installed

By | June 29, 2010

SAS Even though we have Maintenance Release 2 installed on our SAS clients, we will still get undo problems in Excel.  Here is one more step that needs to be performed:

The issue described in SAS Note 36601: Cannot undo changes in Microsoft Excel when the SAS® Add-In for Microsoft Office is installed can be fixed by applying the second maintenance release for SAS 9.2 (TS2M2).

However, after you apply the maintenance release, you must also select the option Always Prompt for Data Source. This option can be found under SAS –> Options on the Tasks page. See Usage Note 37701: Additional SAS® Add-In for Microsoft Office configuration is required to restore functionality of the Undo button in Microsoft Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *