SOLVED

Error opening XML file in Excel

Super Contributor

We are running Office 365 and I am having trouble opening an XML file in Excel. Any help would be appreciated.

 

XML1.png

3 Replies
Kindly check the video link below

https://m.youtube.com/watch?v=wqAxQ5jUK5Q
best response confirmed by Tim Hunter (Super Contributor)
Solution

@Tim Hunter 

DTD is not supported by Excel 2007 and later. Some workarounds are here https://stackoverflow.com/questions/13854068/dtd-prohibited-in-xml-document-exception.

I have the same problem, where I have the same error as the person above. This video did not help. It only gave me the same error I had before.

Please help. The data I am using is the exported iWatch data I would like to open on an excel file. It worked the first time I've done this, but it has not worked since.