In the above: The left is how it appears in Excel when pasted. The right shows how it appears in the SAS Report.    Below shows the Style selected for SAS Report.     ... View more

ODS EXCEL isn't ideal because the SAS Report being copied/pasted is from a step later in a process.  The report is being pasted into a file previously exported using ODS EXCEL so I don't want to recreate it or create a second exported file that has to be merged into the original file.    Process is: Initial file is created using ODS EXCEL User makes selections in the exported file, then uploads the file to update tables on a server A SAS Report with a summary of selections and calculations is created - this is what we have been able to paste into the original file and retain html blue when using version 7.1   Is there an Add-In that's needed or a setting I need to change to keep the formatting when pasting? ... View more