SUPPORT / SAMPLES & SAS NOTES
Problem Note 39204: Cannot save changes to VBA code in Microsoft Excel .xla files with SAS® Add-In for Microsoft Office
 |  |  |  |  |
After the SAS Add-In for Microsoft Office is installed, changes that you make to VBA code in an .xla file are not saved, even though the file appears to save correctly. When you restart Excel and reopen your .xla file, you see that the saved code changes do not appear.
When the Add-In is uninstalled or turned off, changes to .xla files are saved as expected.
Currently, the only workaround is to turn off the Add-In before updating your VBA code.
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.3 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||