Error -1072896636 “DTD Prohibited” when opening xml file in Excel, what do I do?
The workaround is pretty easy. Open the XML file in a text editor and delete the line that is referring to a DTD location. Excel will then create an XML schema according to your XML file.