Problem Note 42064: A copied Microsoft Excel worksheet might not retain SAS® content from the original worksheet
 |  |  |  |  |
If you copy a worksheet in Microsoft Excel that contains SAS content that was added by using the SAS® Add-In for Microsoft Office, the copied and original worksheets might not retain the SAS associations from the original worksheet. For example, if the original worksheet contains SAS data or results from a stored process, when you copy and reorder the worksheet in your workbook, the associations with the SAS data or results might be lost. Sometimes, the first sheet contains the link to the SAS server data or results.
Only the original worksheet should be associated with SAS. Copied worksheets do not retain any SAS associations because copying a worksheet is purely an Excel function. The SAS Add-In does not know when this copy action has occurred.
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 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 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#42064A 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#42064| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-01-11 20:32:05 |
| Date Created: | 2011-01-10 16:18:18 |