Problem Note 15002: Running tasks against entire spreadsheet causes errors in Add-In
for Microsoft Office
In Microsoft Office, if you select the entire worksheet (Ctrl+A) as your
data for a SAS task, an error message appears when you submit the task:
The exception is:
Exception from HRESULT: 0x800A03EC
at System.RuntimeType.ForwardCallToInvokeMember()
at Excel.Range._get_Default(Object RowIndex, Object ColumnIndex)
at SAS.OfficeAddin.ExcelDataSource.GenerateDataStepCode()
The problem occurs because you include the entire spreadsheet (256
columns and 65,536 rows) beyond the scope of your data.
The hot fix alters the behavior so that only the data-filled cells are
sent to the task.
This same error message can also occur if your data exceeds memory
capacity. After applying the hotfix below, an out of memory message
appears.
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/amo131.html#015002
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows XP Professional | 1.3 | 1.3.1 | | |
| Microsoft Windows Server 2003 Datacenter Edition | 1.3 | 1.3.1 | | |
| Microsoft Windows Server 2003 Standard Edition | 1.3 | 1.3.1 | | |
| Microsoft Windows Server 2003 Enterprise Edition | 1.3 | 1.3.1 | | |
| Microsoft Windows 2000 Server | 1.3 | 1.3.1 | | |
| Microsoft Windows 2000 Advanced Server | 1.3 | 1.3.1 | | |
| Microsoft Windows 2000 Datacenter Server | 1.3 | 1.3.1 | | |
| Microsoft Windows 2000 Professional | 1.3 | 1.3.1 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2005-07-14 12:01:21 |
| Date Created: | 2005-04-14 14:55:43 |
