When links in a document attempt to retrieve data from the Working Papers database, Connector must determine with which client file to connect with. To discern which is the appropriate client file, the program behavior depends on these factors:
- Where the Word or Excel document is located with respect to the Working Papers client file.
- Which, if any, Working Papers client file is currently open.
- Which linkage protocol is in use.
The most stable way to use Connector is to:
- Save the Word or Excel document in the client file folder, and
With the client file open in Working Papers, open the Connector document from the Document Manager.
Note: The currently open client file is also referred to as the Active file.
In this setup, a connection is always established to the client file, regardless of the linkage protocol and in the case of UDF links, regardless of whether the client file is open (unless you specify the option Use Client File opened in Working Papers for UDF).
The following table refers to other possible scenarios and their limitations (where links do not explicitly reference a specific client file; that is, use the client_file parameter):
- For multiple client files open on multiple versions of Working Papers see Connecting to Working Papers when Multiple Versions are Installed.
- All documents calculate upon opening, unless otherwise specified. Closing and reopening a document while keeping Word or Excel open, does not trigger a recalculation.
Linkage protocols (DDE and UDF)
CaseWare recommends that Excel documents contain either UDF or DDE linkages exclusively, with UDF being the preferred protocol. Consider the scenario where a document contains both types of links; the associated client file is not open in Working Papers, but the prior year client file is. UDF links in this document will connect to the current year balances of the associated file while DDE links will connect to the prior year client file that is open. The document may appear to be working correctly with Connector, however, the resulting values are inconsistent.
Note: The software installation requirements vary for DDE and UDF linkages. Please refer to the Installation Requirements for more information.
Formulas in your Word or Excel file can be linked to several different Working Papers client files. In the Link Paths dialog box, the paths of each client file referenced in the current document by a DDE-based linkage are displayed as well as the number of links which use those paths. UDF-based link paths are also included in this dialog, but they are meant as a reference only.
Link paths indicate which client file a Connector linkage refers to. The path is to a Working Papers client file and can either be the currently open Working Papers file (the Active file), or a specified Working Papers file.
The Link Paths dialog, accessible from Tools | Link Paths, reports all the link paths for the current document (for both UDF and DDE). This dialog is primarily used for updating multiple DDE-based linkages. Some examples of when to use this feature include:
- After a year-end close to update the links to the new year’s file.
- After copying documents from one client file to another to update links to the new client file.
- When you want to update most or all links to reference a specific client file or the active file.
For more information, see here.