You might lose your formatting in Microsoft Excel under the following conditions:

• You import a SAS Visual Analytics report into Excel.
• You apply user formatting to report objects directly in Excel.

For example, you encounter this issue when you complete steps similar to the following:

1. Create a new report in SAS Visual Analytics that contains a drop-down list on Page1. The drop-down list is based on a parameter that filters all report objects on Page2 and on Page3.

Page2 contains a list table with the following advanced filter:

Note: Based on the advanced filter in the list table on Page2, the following is true:

• When the drop-down list on Page1 is set to DriveTrain (no value selected), all values are displayed in the list table on Page2.
• When the drop-down list on Page1 is set to any values (All, Front, or Rear), no values are displayed in the list table on Page2 because the filter results in an empty set of data.

2. Save the report in SAS Visual Analytics with no values selected in the drop-down list on Page1.
3. Open the report in SAS^® Add-In for Microsoft Office. 
4. Apply formatting to the list table as shown in the image below and save the Excel file:

5. Select All from the drop-down list on Page1. This selection produces an empty set of data for the list table in Page2, which is expected.

6. Reset the DriveTrain\Clear filter value in the drop-down list as shown below:

7. Check the list table on Page2. It has partially lost the formatting as shown below:

To work around this problem, apply formatting to report objects in SAS Visual Analytics rather than in Microsoft Excel.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you have installed the hot fix, you need to perform the following steps to address the issue:

1. Add the following option in your SAS.OfficeAddin.dll.Config file:

2. Ensure that the option Apply the SAS style to the results in Tools ► Options ► Results ► SAS Results is set to Never.

Operating System and Release Information

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

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