• Print |
• E-mail  |
• Bookmark

Filtering failures occur when you open SAS data sets into Excel worksheet pivot tables. As a result, you can receive error messages that include XML exceptions and SAS message severity errors. For example:

Microsoft Excel
<?xml version="1.0"?><Exceptions><Exception><SASMessage severity="Error"
>SQL View WORK.xxxx_xxxxx_xxxxx could not be processed because at least
one of the data sets, or views, referenced directly (or indirectly) by
it could not be located, or opened successfully,
</SASMessage></Exception></Exceptions>

If the hot fix does not fix your problem, please uninstall the SAS Add-In for Microsoft Office from the Control Panel. To do that follow these steps:

1. Click on Start►Settings►Control Panel►Add/Remove Programs.
2. Locate the SAS Add-In for Microsoft Office and click Remove.
3. Reboot your PC.
4. Log in as the Administrator.
5. Reinstall the SAS Add-In for Microsoft Office, by performing the following:

   * From the SAS BI Reporting Clients CD

   1. Insert the SAS BI Reporting Clients CD. After inserting the disk, the SAS Software Navigator loads and two panes appear.
   2. Expand the left pane fully so that "SAS Add-In for Microsoft Office" is selected.
   3. In the right pane, select "Install Instructions" and follow the steps necessary to perform the installation.

   * From the SAS Software Depot

   1. Navigate to your SAS Software Depot location and select the client9cd folder.
   2. Select the client9cd_doc folder.
   3. Expand the en.zip file to find the install.pdf file and follow the steps necessary to perform the installation.
6. Invoke Microsoft Excel to verify that you see the SAS icon on the menu bar.
7. Re-Install the Add-In for Microsoft Office 2.1 Hot Fix from the following link:

   http://ftp.sas.com/techsup/download/hotfix/amo21.html#21amo05

   * IMPORTANT NOTE(S):

   1. You must have The SAS Add-In for Microsoft Office 2.1 installed on your system before applying this hot fix.
   2. You must have local administrator privileges on your machine in order to apply this hot fix.

Select 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 Add-In for Microsoft Office 2.1 is available at:

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