Excel and XML exporting

I have the attached xml file that I uploaded that I attempted to import and source into excel.  It loads but does not allow me to save or export as an xml file.

can someone assist or modify the file to work?
A47162-DeductiblePaymentsInfoCon.xml
RDLFCAsked:
Who is Participating?
 
Steven HarrisConnect With a Mentor PresidentCommented:
When I open the file, I am warned that there is no schema data, so Excel is creating the schema on it's own.  While I am not an expert with XML, I do know that when his issue arises, you can save in XML Spreadsheet 2003 format but no XML Data format.
0
 
Steven HarrisPresidentCommented:
Which version of Excel?

How are you trying to save the file?

After import, I can Save As: XML Spreadsheet 2003 with no issues.
0
 
RDLFCAuthor Commented:
I tried it with 2013 and 2007.  Do you know what limits the schema to working only with 2003?
0
 
RDLFCAuthor Commented:
was not exactly what i was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.