Excel Import/Export stopping working

[dblan]

I have a several SAS programs that create a dataset then then export the data into Excel. Today, after months of no problems, SAS won't export (or import) in Excel97-2002 format. Exporting and importing in Text, CSV, and Excel 5 work fine. Just not Excel97-2002. Anyone else run into an issue like this?

Thanks

 

[klaz2002]

Usually this is due to a change in either SAS versions or perhaps the program no longer has access to the excell files in question.
Klaz

 

[dblan]

I found the solution...wanted to share in case someone else runs into this. It ended up being my printer. My company just installed new printers and it doesn't work well with SAS. I found the solution on

http://www.sas.com.

http://support.sas.com/techsup/unotes/SN/020/020002.html

Dave

 

[ChrisW75]

Thanks for posting the answer! Well done for tracking it down too. Issues like that can be a dog to track down.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.