XML Parsing Error for Microsoft Excel Spreadsheet

[Matthew.LinLi]

Hi there,

I am trying to export data from Excel into XML format. So I saved my
file using the *.xml spreadsheet format.

However when I try to reopen it in a browser, I get an error:

XML Parsing Error: not well-formed
Location: file:///c:/data.xml
Line Number 77, Column 14: ss:Name="%
-------------^

How do you detect where this is in the XML file?

TIA,Matthew.

 

[Bryan Hessey]

Did you try to open the file in Notepad and search for ss:Name="%

Perhaps this will locate the fault, and give you a clue as to the
surrounding data.

Hope this helps

--