Usage Note 40187: Unreadable content errors when exporting to Excel sheet names that are the same as an Excel column name
When opening Excel files created by the SAS EXCEL engine, you can receive the following error:
Excel found unreadable content in 'YourWorkbookName'
Do you want to recover the contents of this workbook? If you trust
the source of this workbook click yes.
When you open the file, you can receive the error:
Removed Records: Named range from /xl/workbook.xml part (Workbook)
The problem occurs when the worksheet or SAS data set is named the same as a cell address. This causes issues with the Microsoft ACE engine when it creates the range address as it matches a cell column name. The following is a sample of this: