SUPPORT / SAMPLES & SAS NOTES
Problem Note 37727: Microsoft Excel files saved in SAS® folders are not automatically refreshed when opened
 |  |  |  |  |
Microsoft Excel files that have been saved to a SAS folder will not reflect changes to the underlying data when opened, even when Refresh on file open is selected. Refreshing the data manually by using the Refresh button will update the file with the latest data.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M2 | ||