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. Disable XML-RPC via snippet
  50. MS Excel Scatterplot converts Months to Numbers
  51. Substring in excel
  52. IndexError: too many indices for array
  53. IndexError: too many indices for array
  54. What does <> mean?
  55. Excel to Google Sheets – Error: Formula parse error
  56. How to pretty print XML from the command line?
  57. How do I comment out a block of tags in XML?
  58. What does “xmlns” in XML mean?
  59. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  60. IndexError: too many indices for array
  61. Swap x and y axis without manually swapping values
  62. Excel: Calculate the frequency of a particular month in a column of date cells
  63. How to convert JSON to XML or XML to JSON?
  64. How to parse XML and count instances of a particular node attribute?
  65. Help needed with Median If in Excel
  66. Invalid column count in CSV input on line 1 Error
  67. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  68. Invalid column count in CSV input on line 1 Error
  69. How to find a value in an excel column by vba code Cells.Find
  70. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  71. What characters do I need to escape in XML documents?
  72. Object Required Error in excel VBA
  73. “Content is not allowed in prolog” when parsing perfectly valid XML on GAE
  74. excel IF formula Error, “You’ve entered too many arguments”
  75. Insert picture into Excel cell
  76. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  77. What is a correct MIME type for .docx, .pptx, etc.?
  78. Is there Infinity in Spreadsheets?
  79. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  80. How to fix file format and extension don’t match?
  81. Declaring variables in Excel Cells
  82. Convert XML to CSV file
  83. What are .NumberFormat Options In Excel VBA?
  84. What is the best/simplest way to read in an XML file in Java application?
  85. Better way to find last used row
  86. VBA, if a string contains a certain letter
  87. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  88. How do I read and parse an XML file in C#?
  89. Text editor to open big (giant, huge, large) text files
  90. How to loop in excel without VBA or macros?
  91. Opening JSF Facelets page shows “This XML file does not appear to have any style information associated with it.”
  92. How can I open an Excel file in Python?
  93. XML Parsing Error: no root element found Location in Console FF
  94. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  95. ValueError: cannot index with vector containing NA / NaN values
  96. Excel VBA Macro: User Defined Type Not Defined
  97. Converting XML to JSON using Python?
  98. How can I import an Excel file into SQL Server?
  99. How To Auto-Format / Indent XML/HTML in Notepad++
  100. What is correct content-type for excel files?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)