Starting with SAS Web Report Studio 4.2, the recommended way to view reports in Microsoft Office products is to use the SAS^® Add-In 4.2 for Microsoft Office (or later).

Note: You also can open reports directly in SAS^® Enterprise Guide^® 4.3.

For the most consistent results, you should modify the SAS Add-In options to apply the same style used by the report. For example, the following display shows a report that is using the built-in Meadow style sheet.

To ensure that the Meadow style is applied when the report is opened in Microsoft Excel, perform the following steps:

1. Access the SAS tools. For example, select the SAS ribbon.
2. Select Tools ► Options and click the Results tab.
3. Select the option to apply the SAS style to results and then select Meadow. (The name of the option depends on which version of the SAS Add-In you are using. The following display shows the option in version 5.1.)



4. Click OK.

To open the report, perform the following steps:

1. Select Reports, navigate to the report location, and click Open.
2. Specify the location to insert the report and click OK.

The report is opened with the Meadow style sheet applied, as shown in the following display.

Note: For a related style issue, see SAS Note 43140.

Note: SAS Web Report Studio does not export reports in native Excel format (.xls). As a result, if you use the SAS Web Report Studio export feature to open reports in Excel, you might experience the issues described in SAS Note 30964.

Operating System and Release Information