The question seems to have been asked a while ago, but I couldn't find an easy fix on the web, thought I would share something that worked for me. I am currently using SAS 9.4 and had the problem when exporting to a particular sheet to a workbook (with the replace option, as I needed it to replace the sheet). Not the scientific fix that worked for me was saving the spreadsheet I was exporting to, i.e. the template on a different Sheet to the one I was planning to export to and replace. This prevented SAS from wiping out the rest of the workbook. Also add DATA _null_ ; asleep = Sleep(10) ; RUN ; before every export to the workbook, makes SAS sleep for 10 seconds.
... View more