Common issues in Word

You may encounter the following issues when using Connector in Word:

Connector works in Excel but not Word

Microsoft Word's built-in security measures may be preventing Connector from functioning.

Solution:

  1. From the File menu, click Options.
  2. In the Word Options dialog, click the Trust Center tab.
  3. In the Trust Center pane, under the Microsoft Word Trust Center group, click Trust Center Settings....
  4. In the Trust Center dialog, click the Trusted Locations tab.
  5. Click Add new location... and enter the path of Caseware Connector. Ensure Subfolders of this location are also trusted is selected. Click OK.

Excel instability caused by Word documents with embedded Excel content

If an Excel spreadsheet embedded in a Word document contains DDE Links, Excel may become unstable when opening the Word document.

Workaround: Convert the DDE links within the Excel spreadsheet to UDF links, or choose to update the automatic links within the spreadsheet by doing the following:

  1. Open the Word document that contains the embedded Excel spreadsheet.
  2. Use the Recalculate functionality in Connector.
  3. Click on the Microsoft Word Update link option to synchronize the data.

Excel instability when the Linkage dialog is open in Word documents with embedded Excel content

After leaving the Linkage dialog open within an embedded spreadsheet in a Word document and closing a separate instance of Excel, Excel launches unexpectedly when switching back to the Word document. An Excel window will also appear that cannot be closed. The window will only disappear when the embedded spreadsheet becomes non-active. If you try to close the window, a crash may occur. This is an Excel issue when working in an embedded spreadsheet in Word.

Workaround: Ignore the window that appears when working in the embedded spreadsheet when Excel is opened in the same instance.

Excel instability after embedding a Word document with Excel content

If a cell appears with a marquee in an embedded Excel spreadsheet, Excel will stop working when users click anywhere outside of the embedded spreadsheet. A marquee appears around a cell as a flashing, dashed outline. Common functions like cut, copy, and paste can leave cells in this state.

Workaround: Before clicking outside of the embedded spreadsheet, ensure that a marquee is not present. Double-click anywhere inside of the embedded spreadsheet to remove it.

Links display as #N/A when pasting Excel content containing UDF links into a Word document

Solution:

  1. Double-click on the table and select Formulas | Calculation Options | Automatic.
  2. Right-click on the Word document, outside of the embedded table, and click Connector | Recalculate.