Excel 2010 limited to 65535 rows

[khill]

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

[LinusH · Accepted solution]

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

[khill]

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

[Wayne_PSU]

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.