When you use the ExcelXP tagset, you are creating Spreadsheet Markup Language XML -- which is the Microsoft definition (in XML format) for a workbook/worksheet. Generally, this error means that the XML that you are generating is not recognized by Excel as being valid. This kind of error is generally a signal that you need to download the newest (updated) version of the ExcelXP tagset. Tech Support can help you figure out how to do this. Or, you can read about the various versions of the tagset at this site: http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html
and then decide which one you want to download from here: http://support.sas.com/rnd/base/ods/odsmarkup/ (scroll down to the middle of the page and look for ExcelXP)
If you are using the most updated version of the tagset and you are still getting this message, then you should contact Tech Support for help in figuring out how to generate valid XML for Excel.
just paste the path into a windows explorer address bar, and the files in that folder will appear, including the one referred. Open the 4A80BD4.log file in notepad to see invalid tags and other things broken in your ods style. Each time excel fails to open an xml file, it writes a new .log file with its interpretation of the problem into that hidden folder
I get this error all the time and it is a pain in the a$$. The file that is named is a hidden file so you don't see it when you look for it. You need to enter the entire name (which is ridiculously long) before the system will show you the contents of the file.
Once you open the file it is still difficult to identify the error because the messages are cryptic and hard to relate back to the data that you are using.
I find that usually there is an error in the SAS log that relates to the problem preventing the XML from opening. There is usually a format that you tried to use that is missing, or you have macro variables that failed to resolve.