Excel file warning - different format than file extension

[Kurt_Bremser]

---

@saikiran_nemani wrote:
SAS 9.3 and excel oss is not working

---

Then you should use tagsets.excelxp and a .xml extension.

[Tom]

You should also ask yourself (or your company) why you are still using a version of SAS that was last updated 7 years ago?
https://blogs.sas.com/content/iml/2013/08/02/how-old-is-your-version-of-sas-release-dates-for-sas-so...

[saikiran_nemani]

ODS LISTING;

ODS TAGSETS.EXCELXP FILE='/SAS/SAI/REPEAT_SUMMARY.XLS'

ODS TAGSETS.EXCELXP CLOSE;

[Reeza]

The extension must be xml., Excel will still open the file, though it may not be the default application.

ODS TAGSETS.EXCELXP FILE='/SAS/SAI/REPEAT_SUMMARY.XML'

---

@saikiran_nemani wrote:
ODS LISTING;

ODS TAGSETS.EXCELXP FILE='/SAS/SAI/REPEAT_SUMMARY.XLS'

ODS TAGSETS.EXCELXP CLOSE;

---

[Cynthia_sas]

If you persist in using .XLS as the file extension for TAGSETS.EXCELXP steps, you will continue to get the Microsoft warning. This is a MICROSOFT requirement that the file extension match the contents of the file.

Again, the correct file extension to use with TAGSETS.EXCELXP is .XML -- NOT .XLS because TAGSETS.EXCELXP is creating Spreadsheet Markup Language XML and Microsoft wants the output file to have the correct extension. Otherwise, change the registry, as I explained earlier based on the Tech Support note.

Cynthia

[Kurt_Bremser]

How often do we need to tell you that you HAVE TO USE THE CORRECT EXTENSION?

If you do not want to take our advice, then why are you here at all?