Common Issues in Word
The following topic outlines some of the common issues experienced when using Connector in Word.
- Connector works in Excel but not Word
- Opening a Word document with an embedded Excel table containing DDE Links causes Excel to become unstable
- Leaving the Linkage dialog open within an embedded Excel spreadsheet in Word causes Excel to become unstable
- Embedding an Excel spreadsheet in a Word document causes problems when clicking outside of the spreadsheet
- Pasting an Excel table containing UDF links into a Word document causes links to display as #N/A
Connector works in Excel but not Word
Microsoft Word's built-in security measures may be preventing Connector from functioning.
Solution:
- From the File menu, click Options.
- In the Word Options dialog, click the Trust Center tab.
- In the Trust Center pane, under the Microsoft Word Trust Center group, click Trust Center Settings....
- In the Trust Center dialog, click the Trusted Locations tab.
- Click Add new location... and enter the path of CaseWare Connector. Ensure Subfolders of this location are also trusted is checked. Click OK.
Opening a Word document with an embedded Excel table containing DDE links causes Excel to become unstable
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:
- Open the Word document that contains the embedded Excel spreadsheet.
- Use the Recalculate functionality in Connector.
- Click on the Microsoft Word Update link option to synchronize the data.
Leaving the Linkage dialog open within an embedded Excel spreadsheet in Word causes Excel to become unstable
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.
Embedding an Excel spreadsheet in a Word document causes problems when clicking outside of the spreadsheet
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.
Pasting an Excel table containing UDF links into a Word document causes links to display as #N/A
Solution:
- Double-click on the table and select Formulas | Calculation Options | Automatic.
- Right-click on the Word document, outside of the embedded table, and click Connector | Recalculate.