topic Excel 2010 limited to 65535 rows in Microsoft Integration with SAS

Excel 2010 limited to 65535 rows

khill — Wed, 03 Aug 2011 20:50:16 GMT

Hello,

I'm running the attached configuration. While perfroming a send to Excel I received this warning message;

The data being sent contains more rows (2714162) than will fit in one

Excel worksheet (65535). To send the first 65535 rows to Excel press

“OK”; otherwise, press “Cancel” to abort.

This worked fine before my upgrade to Office 2010. Any thoughts as to why and more importabtly how to overcome?

EG 4.3

Office Plugin 4.3

Windows 7

Office 2010 (64 bit)

Thanks,

John

Excel 2010 limited to 65535 rows

LinusH — Mon, 08 Aug 2011 11:59:20 GMT

I don't know whether it's causing your problem, but I think that only 32-bit MS Office is supported by the SAS Add-on for MS Office.

/Linus

Excel 2010 limited to 65535 rows

khill — Mon, 08 Aug 2011 18:54:06 GMT

That appears to be the case as per this kb article

http://support.sas.com/kb/38/120.html

"Note: Office 2010 support is only for 32-bit Office 2010. Even if the Windows operating environment is 64-bit, only 32-bit Office 2010 is supported. Support for 64-bit Office 2010 is planned for a future software release."

This would have been good to know during installation.

John

Excel 2010 limited to 65535 rows

Wayne_PSU — Mon, 08 Aug 2011 20:26:29 GMT

I've just installed SAS-EBI 9.3, Add-in 4.3, but the client (Windows XP Pro) is running a 32bit version of Office 2010 and I have the same limit, but I'm not receiving any message/warning.