What is CaseWare Connector

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 Connector's Linkage dialog, you can easily retrieve a variety of Working Papers data. You can create generic documents that can be copied over multiple client files for financial statements, lead sheet schedules, and other custom documents. Additionally, you can create references that open to specific parts of your Working Papers file, such as line items on adjusting entries, reports, and automatic documents.


Working Papers

Connector enables you to link information such as engagement properties, balances, and adjusting entries from your client file. Using Connectorfunctions, you can create links that access the Working Papers database. You can also use the Linkage dialog to generate appropriate links for your document.


Linkage protocols

Linkage protocols determine how Connector establishes the connection to Working Papers. Generally, Word documents use the Dynamic Data Exchange (DDE) protocol and Excel documents use the User Defined Function (UDF) protocol. Both linkage protocols are supported with Connector to provide the best coverage and functionality available with Microsoft add-ins.

Connecting

Connector automatically attempts to establish a connection to the Working Papers database. However, there are certain factors that must be taken into account when using Connector. These factors are dependent on the linkage protocol in use, where the document is saved relative to the Working Papers client file, and which client file is currently open in Working Papers.

    • Related Articles

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