Select a linkage protocol
You can use the Dynamic Data Exchange (DDE) protocol or the User Defined Functions (UDF) protocol to establish a connection between Word or Excel and the Working Papers database, allowing data to transfer between them seamlessly.
To select the DDE linkage protocol:
- On the Add-ins tab, in the Connector group, click Tools | Options.
- In the Options dialog, deselect Use Connector User Defined Functions (UDF).
- In the Link Path Type drop-down menu, select Active Client.
- Click OK.
To select the UDF linkage protocol:
- On the Add-ins tab, in the Connector group, click Tools | Options.
- In the Options dialog, select Use Connector User Defined Functions (UDF).
- In the Link Path Type drop-down menu, select Active Client.
- Click OK.
You have selected your linkage protocol.
CaseWare recommends that your documents contain either DDE or UDF linkages exclusively. We also recommend using UDF rather than DDE, as UDF offers enhanced functionality and stability over DDE.
Note: If a document contains both UDF and DDE linkages, values will not be retrieved from the same source file, and will be inconsistent. You can change link paths to ensure that links connect to the same source file, or convert DDE links to UDF to help resolve any discrepancies.
To see a comparison between DDE and UDF linkage protocols, refer to the following table:
Category | DDE links | UDF links |
---|---|---|
Active Working Papers sessions | Only one session of Working Papers can be active while working with Connector. | Multiple sessions of Working Papers can be active while working with Connector. |
Link evaluation | The link is only evaluated if Working Papers is running. | The link is evaluated even if Working Papers is not running, as long as Connector can establish a connection to the Working Papers database. |
Vulnerability | Attempts a connection with every running application. May cause Word or Excel to stop responding. | Attempts a connection with Working Papers only. |
Referencing | Cannot use Excel references in formulas. | Can use Excel references in formulas. |
Linking to a Working Papers file | You must specify the Client GUID or Client Path in each link to retrieve the values. If the Working Papers file path does not exist, Excel may stop responding. | You must specify the Working Papers file by Client Path, Client GUID, or reference to the cell where the Path or GUID is defined. If the Working Papers file path does not exist, Connector returns an error. |
Editing | In Excel, you must link formulas manually to a new cell. | In Excel, you can copy formulas to a new cell and the reference will automatically update the cell address accordingly. |
To see the difference between DDE and UDF linkage syntax, refer to the following table:
Category | Syntax |
---|---|
DDE links |
The DDE link protocol is defined by:
The data you are linking is defined by:
The bolded syntax is the Working Papers link path. You can select the Link Path Type in Tools | Options. Active client
Client GUID
Client path
|
UDF links |
The UDF link protocol is defined by:
The data you are linking is defined by:
The bolded syntax is the Working Papers link path. You can select the Link Path Type in Tools | Options. Active client
Client GUID
Client path
|