Export into excel 2010

[deleted_user]

I have SAS EG 4.1 and excel 2010.
Is it possible to export SAS dataset into excel 2010 which has more than 65k rows?. I tried to export SAS data with 80k rows, however am getting an error message - "An error ocurred saving the file. Spreadsheet is full." Any suggestions? Thanks.

[twocanbazza]

I would check with Tech support, but would suspect 4.1 is not supported/compatable with office2010 products.

Barry

[Technolero]

EG 4.1 will only export to an .xls file, not the .xlsx format used by Excel 2007 and 2010 that allow more than 65k rows. I suggest you export to a .csv file which will export fine and be utilized by Excel 2010.