SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Excel crashes after running SP

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Excel crashes after running SP

Hi,

My excel gets crashed every time when I try to save it after pulling data from SAS stored procedure.

ExcelCrash.png

Did any one face this issue before or have any suggestion to fix this?

Thanks


Accepted Solutions
Solution
‎12-31-2014 11:20 AM
Frequent Contributor
Posts: 89

Re: Excel crashes after running SP

It seems incompatibility with the version of .NET on my machine was causing this issue.

I applied following Hotfix to correct this:

http://support.sas.com/kb/53301

View solution in original post


All Replies
Respected Advisor
Posts: 2,917

Re: Excel crashes after running SP

Has this only just started happening or has it never worked? Do other SAS users have the same problem or is it just your PC? Rather than waste a lot of time troubleshooting I suggest you try re-installing the SAS Add-In to Microsoft Office as a starting point.

Frequent Contributor
Posts: 89

Re: Excel crashes after running SP

Its a problem from long time and everyone in my team is facing this issue. I already re-installed SAS Add-In to Microsoft Office but no luck!!

Respected Advisor
Posts: 2,917

Re: Excel crashes after running SP

I suggest you track this to SAS Tech Support in that case.

Esteemed Advisor
Posts: 5,988

Re: Excel crashes after running SP

Try running the stored process from EG, and save the results to an Excel file. Then see if it is something in the data that causes Excel to crash.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Frequent Contributor
Posts: 89

Re: Excel crashes after running SP

I ran that SP in EG and send data to Excel. But when I tried saving that Excel, I got following error:Excel Issue.png

This is the case with simple data export (SASHELP.CLASS) as well. No idea whats going on here.

Grand Advisor
Posts: 9,748

Re: Excel crashes after running SP

Long shot: Is your SAS a 32-bit version and Excel 64 bits or vice versa?

Esteemed Advisor
Posts: 5,988

Re: Excel crashes after running SP

Don't do "Send to Excel". That's about as crappy as can get, basically it means that SAS simulates an Excel user typing in values. Takes forever and a day with big data. And is completely dependent upon what your Excel version of the day _thinks_ you wanted to "type".

Save/Export the data to a file and then open that from Excel.

My personal favorite for getting data into Excel is tagsets.excelxp. Works on all SAS platforms and completely avoids the microcrap while working with SAS.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎12-31-2014 11:20 AM
Frequent Contributor
Posts: 89

Re: Excel crashes after running SP

It seems incompatibility with the version of .NET on my machine was causing this issue.

I applied following Hotfix to correct this:

http://support.sas.com/kb/53301

Post a Question
Discussion Stats
  • 8 replies
  • 1509 views
  • 0 likes
  • 4 in conversation