CaseWare Connector linkage to worksheet error

CaseWare Connector linkage to worksheet error: #NAME

When your linked worksheet within CaseWare defers to #NAME, it is an indication of a problem with CaseWare Connector. 

1. Open Excel. Look for the 'Add-Ins' tab in the top ribbon.

  • If the Add-Ins tab is there, then proceed to Step 2.
  • If the Add-Ins tab is not there, you must reinstall Connector on your computer.

2. Within Excel, go to 'File' and then 'Options'.

3. In the dialog box that opens, proceed to the 'Add-Ins' screen.



4. From here, browse amongst Inactive Application Add-Ins and Disabled Application Add-Ins to identify whether your necessary Connector Add Ins are inactive or disabled. Below are the three Add-Ins you must have active for proper use of CaseWare Connector.



5. To enable any or all of these Add-Ins if found disabled or inactive, go to to the 'Manage' dropdown and search for the relevant Add-In type to generate a list.



6. Tick the required Add-Ins and press OK.





This should render CaseWare Connector Add-Ins active and fix the #NAME error.



    • Related Articles

    • Connector Getting Started 1: Basic Connector Linkages

      Within minutes of watching the Caseware Connector Getting Started videos, build simple automated Excel® Working Papers and link up Word documents to Caseware engagement data. 

    • How do I send a document to an external reviewer if they do not have Connector

      The Unlink option enables you to embed the current value of links within the document, effectively replacing the linkage formula with its value instead. When unlinking a document, the current values remain in place and the document becomes an ...

    • What is CaseWare Connector

      Connector is an add-in for Microsoft® Word and Microsoft® Excel® that enables you to link data between Working Papers and Microsoft documents. The Connector Add-in appears as its own toolbar in Microsoft® Word and Microsoft® Excel®. Using ...

    • How to reference the ABN number using Connector

      CaseWare Connector allows users to connect to most of the Engagement Properties' fields in CaseWare Working Papers. However, one field is currently not available to select in CaseWare Connector, is the E.I.N / BN field. This field is used for ...

    • Rename CaseWare Engagement Files

      Note the following: An engagement file cannot be renamed within Windows Explorer. The rename function is not available when you currently have an engagement file open. To rename the file, you would need to be out of the file. (File > Close will ...