How do I modify a Connector formula or link?

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

  1. Select the existing link in Excel or Word.

  2. Modify the function using:

    • The Linkage dialog by clicking .
    • The insert function dialog by clicking .
    • The calculation bar to manually modify the function.
  3. Review the resulting value.
  4. Apply the new link by clicking Accept () or OK.

Note: Copy/Pasting UDF links, while Use Client File opened in Working Papers for UDFs and Use Connector UDF are unchecked, may result in different behavior in Excel and Word.


DDE

  1. Select the existing link in Word or Excel.
  2. Access the Edit dialog:
    • In the Connector toolbar, click Tools | DDE Links | Edit DDE Link, or
    • Right-click and select Connector | Edit DDE Link.
  3. Modify the function as necessary. Ensure to use the syntax for DDE formulas.
  4. Click Recalculate to review the resulting value.
  5. Click OK.

    • Related Articles

    • 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 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 ...

    • 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 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 ...

    • 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 ...