Error opening XML file in Excel

[Tim Hunter]

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

[#2]

Kindly check the video link below

https://m.youtube.com/watch?v=wqAxQ5jUK5Q

[#3 · Accepted 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.

[#4]

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.