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.

Related Posts:

  1. Looking for a clear description of Excel’s .xlsx XML format
  2. How do I comment out a block of tags in XML?
  3. What does
  4. How to use XPath contains() here?
  5. Parse XML using JavaScript [duplicate]
  6. (Python) AttributeError: ‘NoneType’ object has no attribute ‘text’
  7. XSLT-FO for-each
  8. java.net.MalformedURLException: no protocol
  9. Meaning of –
  10. XSLT for each loop on simple XML
  11. Is XML a programming language?
  12. XML Parsing Error: not well-formed
  13. XPath: Get parent node from child node
  14. What is the difference between Inclusive and Exclusive OR?
  15. Manifest Merger failed with multiple errors in Android Studio
  16. xmlns, xmlns:xsi, xsi:schemaLocation, and targetNamespace?
  17. How can I escape “&” in XML?
  18. How to fix error: The markup in the document following the root element must be well-formed
  19. What’s “tools:context” in Android layout files?
  20. How to add a newline (line break) in XML file?
  21. How to define xsi:type as an attribute in XML-schema?
  22. What are invalid characters in XML
  23. How to implement if-else statement in XSLT?
  24. The ‘packages’ element is not declared
  25. Getting attribute using XPath
  26. understanding position() function in XSLT
  27. android.support.design.widget.CoordinatorLayout error
  28. How to parse XML in Bash?
  29. YAML compared to XML
  30. URI is not registered (Settings | Languages & Frameworks | Schemas and DTDs) in applicationContext.xml
  31. Import WordPress xml file larger than 8mb
  32. parse XML from URL (via SOAP)
  33. How can I bulk update all posts without making changes?
  34. Problems with creating hook that updates XML
  35. Features in Houzez are not loading in Backend from API
  36. WP All Import: Feeds of Feeds [closed]
  37. Is there an XML Web Service that can get posts, categories and other data from the site?
  38. Receive error exception using xampp with wordpress
  39. Work with xml file and WordPress
  40. Moving WordPress to a different directory – update XML Post File?
  41. WordPress importer / problem with images
  42. I need a standalone script in web root but still have access to the database
  43. stop duplicate post
  44. Importing feeds with PHP
  45. Create XML sitemap in wordpress
  46. How to make an xml file (just the xml file) available at a specific url?
  47. problem of path with xml file
  48. xml generator script wordpress [closed]
  49. IndexError: too many indices for array
  50. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  51. Swap x and y axis without manually swapping values
  52. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  53. How to find a value in an excel column by vba code Cells.Find
  54. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  55. Convert XML to CSV file
  56. What are .NumberFormat Options In Excel VBA?
  57. VBA, if a string contains a certain letter
  58. How do I read and parse an XML file in C#?
  59. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  60. How To Auto-Format / Indent XML/HTML in Notepad++
  61. How do you parse and process HTML/XML in PHP?
  62. Converting JSON to XML in Java
  63. In_array not working
  64. check if a file is open in Python
  65. How to return a result from a VBA function
  66. Exception from HRESULT: 0x800A03EC Error
  67. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  68. How do I open space-delimited file in Microsoft Excel?
  69. Scraping data from website using vba
  70. How to open an Excel file in C#?
  71. How to convert array to SimpleXML
  72. How do I escape ampersands in XML so they are rendered as entities in HTML?
  73. How to install Date Picker form control in Excel 2016
  74. XML has empty body?
  75. Average in VBA in Excel
  76. Paste Special error 1004 PasteSpecial method of Range class failed
  77. Import WordPress XML File from Within Functions.php
  78. Is it possible to export WordPress from command line?
  79. How do you get all the urls of images attached to a post?
  80. How to add featured image or custom field to xml feed?
  81. How can I export post data in xml format?
  82. Best practice to import/export specific pages and posts
  83. Why does SVG upload in Media Library fail if the file does not have an XML tag at the beginning?
  84. How to limit the content coming from wordpress shortcodes?
  85. Importing XML to WordPress, permalink problem
  86. Widget with same content across several websites
  87. Rewrite WordPress Standard Feed URL – /feed/ to feed.xml
  88. XML-code sent via the POST method to the URL (API) [closed]
  89. Attach images to posts using custom fields (just paths to images already uploaded)
  90. Import post from XML files into custom post type programatically [closed]
  91. How to get xml file for a single post type?
  92. How to process shortcodes in XML-RPC
  93. Fetching review value using wpdb class
  94. Force a 403 response to xml file in WordPress
  95. Posting XML in comment section
  96. Convert javascript running xml files to wordpress platform
  97. When importing posts to a new site if XML file has postmeta not setup on new server what happens?
  98. Xml output not places where i want
  99. how to iterate through xml data?
  100. Export Posts Without Categories In An XML File

Leave a Comment