Until shown today, I didn't know you could right click on a SAS table and select "Open in Excel". As a coding dinosaur I'm used to using the SAS library viewer, viewtable, FSView, SAS System viewer and EG to browse data.
My colleague reported an issue with this functionality that started today. It worked for me when I tried it, so it isn't obviously a security patch, yet after SAS has done all that lovely ODS HTML to write a temporary, her machine prompts her about whether she wants to allow the file to be opened.
Since it is ODS under the bonnet I have listed it here, but if no-one has any ideas we'll raise it with Tech Support. I think we might also restart Windows.
Something like this used to happen with RTF files...when you tried to open it, you got a prompt about whether it was OK to "download" the file, even though no "download" was really happening.
I remember the fix was some registry (Windows) setting. And you probably should contact Tech Support. Here's the FAQ for that RTF popup -- I'm not exactly sure whether this fix would apply to your issue. http://support.sas.com/faq/040/FAQ04022.html
David...the default process uses ODS HTML and gives the file an extension of .XLS -- which should not normally be a problem. The default process in SAS; however, is followed by a dm command to "winexecfile" to open the .XLS file.
So it's possible that there is some disconnect between SAS when it issues the winexecfile command and the download message.