Problem Note 43128: Forced out of edit mode when using the SAS® Add-In for Microsoft Office to edit a SAS® table in Microsoft Excel
 |  |  |  |  |
When you are editing a SAS table using SAS Add-in for Microsoft Office, you might be forced to exit edit mode after making a modification to the data. This action might be taken if you have multiple tables open in Excel and at least one table meets one of the following conditions:
- The table is stored in a range rather than a table, which can occur if the data wasn't opened into a table or you converted the table to a range. To verify that the SAS table is being opened as a table, select SAS ► Tools ► Options ►Data and verify that the Open data into an Excel Table option is selected. If the table was converted to a range in Excel, select Home ► Format as Table, and then select a table format for the range.
- The table dimensions have changed from the original data size, which might happen if you add a row or column to the view of the data in the Excel spreadsheet. Taking this action modifies the dimensions of the viewed table, not the actual physical table. To reset your dimensions back to the original table size, simply refresh your 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.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C46.html#43128A fix for this issue for SAS Add-in for Microsoft Office 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D19.html#43128| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-08-10 15:11:16 |
| Date Created: | 2011-05-02 11:23:10 |