When working with Microsoft Excel files in SAS Enterprise Guide, an issue might occur where the latest version of a file is not displayed. This issue occurs when you first open the file via the Servers window, then modify the file, and reopen the file in Microsoft Excel. In this scenario, SAS Enterprise Guide continues to display the old version of the file due to caching.

This issue occurs when you complete steps similar to the following:

1. Create a Microsoft Excel file. Use any valid method within SAS Enterprise Guide to create a Microsoft Excel file. There are various ways to create a Microsoft Excel file, such as the following:
   • the EXPORT procedure
   • ODS EXCEL
   • interactively within a SAS Enterprise Guide process flow
     • Right-click a SAS data set and select the following: Share ► Export (see Exporting Data Files) or Share ► Export as a step in project (see Exporting Data or Code Files as a Step in a Project).
2. Open the Microsoft Excel file.
   1. Navigate to the Servers window.
   2. Locate the server where you created the Microsoft Excel file.
   3. Double-click the file under the Files section to open it in Microsoft Excel.
3. Close the file in Microsoft Excel.
4. Re-run the program in SAS Enterprise Guide.
   1. Execute your program again in SAS Enterprise Guide. Note that the data changed.
   2. Double-click the newly generated Microsoft Excel file in the Servers window.
   3. Old values are displayed instead of the updated values.

This issue occurs because SAS Enterprise Guide caches the Microsoft Excel file, leading to the display of outdated values even after you modify the file.

Workaround

To avoid this issue, ensure that you always view the latest version of the Microsoft Excel file by completing the following steps:

1. Right-click the Microsoft Excel file in the Files navigation pane.
2. Select Open in File Explorer.
3. Double-click the file in Windows Explorer to open it.

This issue has been fixed in SAS^® Enterprise Guide^® 8.6.