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 ...
    • How do I modify a Connector formula or link?

      You can edit formulas to modify or correct Connector links in Word or Excel documents. Prerequisites Ensure Connector can establish a connection to the source client file. Procedure This procedure is different for DDE links and UDF links. UDF Select ...