DriveWorks Pro 15: How To: Troubleshoot Documents (KB13022702) [send feedback...]

Cannot Load or Preview Excel Document

Dynamic Data Exchange

When DriveWorks loads an Excel document or attempts to generate a HTML preview, you may see the following message:

The cause of this is Microsoft Excels ability to interact with other applications through custom written functions and code, which is know as Dynamic Data Exchange.

This setting, in Microsoft Excel, is turned on by default. To turn off the setting:

  1. Open Microsoft Excel and launch Excel Options (from the Office button in Excel 2007 or later)
  2. Select Advanced and locate the General section
  3. Deselect the option Ignore other applications that use Dynamic Data Exchange (DDE)

Missing or Broken References

If the Excel document contains missing or broken references the following message will appear when attempting to preview the document:

To correct this issue:

  1. Close the DriveWorks project that contains the Excel document.
  2. Open the document that cannot be previewed directly in Microsoft Excel.
  3. In Excel activate the 'Formulas' tab.
  4. Launch the 'Name Manager' dialog and check for any #Ref values. Any #Ref values or any invalid Named Ranges should be fixed/deleted.
  5. Save the Excel document and close.
  6. Open the project in DriveWorks and Edit the document in Stage 4. Output Rules> Documents. Click Refresh in the Named Ranges section.

Document not created

Common causes of documents not being created include:

  • Document hidden from list (not applicable to Email or ODBC Data Export documents).
    1. In the DriveWorks Administrator task explorer select Stage 4. Output Rules>Documents. Select the document that is not shown from the Documents list
    2. Click Edit. Review the General Setting - Hide from documentlist.
  • Output -File Name
  1. The File Name rule could be preventing creation - See  How To: Diagnose Project Issues Using Specification Test Mode

Check the Document Name rule for:

  • Use of illegal characters in the result of the Document Name parameter
  • The Document Name parameter equals "Delete". This will not produce the document.
  • Output File Path
  1. The Document Path rule could be preventing creation - See  How To: Diagnose Project Issues Using Specification Test Mode

Check the Document Path rule for:

  • Use of illegal characters in the result of the Document Path parameter
  • If the Document Path parameter is located on a network drive, ensure the machine has access to that location.
  • If the Document Path parameter is located on a network drive, ensure the user logged onto the machine has permission to write to that location.
  • Document Master File - If the data has been moved the document master file could be missing.
    1. Select the document from the documents list of Stage 4. Output Rules > Documents in DriveWorks Administrator
    2. Click Edit
    3. In the Master File section, click Browse at the end of the Path field
    4. Browse to the new location of the master document


Knowledge Base Article Ref:KB13022702

Table of Contents