Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

When importing report data as XML into an Excel file you may encounter the error DTD is Prohibited. We believe this to be an Excel bug that occurs in the following scenario:

  1. Excel deployed via ClickOnce
  2. Connected to XML data via From Other Sources → Web
  3. Refreshing the data connection

On the backend Excel is truncating the URL at 115 characters. This makes diagnosing the issue difficult as it seems to randomly work on some URLs and not others.

You should use Excel - Import CSV instead of XML. It is a far better method and avoids this bug.


  • No labels