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

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

    • 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 format Connector values in Microsoft Word

      Transform Caseware Connector values in Microsoft Word by adding custom character formatting to the cell calculation. This can be used to present numbers in a neater presentation, such as 10000 to $10,000.00. 1. Insert data by selecting the Caseware ...