When you create a SAS Visual Analytics report that contains Display Rules with decimal value intervals, Microsoft Excel might close unexpectedly if you open the report in SAS^® Add-In for Microsoft Office. This problem occurs only if you set the Windows Regional Settings to French on the client machine on which Microsoft Excel and SAS Add-In for Microsoft Office are installed.

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

1. Create a new SAS Visual Analytics report that contains a list table.
2. Create new Display Rules for the list table.
3. Use decimal values for all intervals, as shown for Age below: 

4. Save the report.
5. Open Excel and display the report.
6. On the Results tab on the right, double-click any row in the table:

Excel closes unexpectedly and the following exceptions occur in the Excel.log:

As a workaround, set your Windows Regional Settings to English.

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 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: