Connect to Working Papers
Connector linkages retrieve information from Working Papers databases. To establish the appropriate database connection, there are certain factors you need to consider:
- Where the Word or Excel document is located relative to the Working Papers file
- If the Working Papers file is currently open
- Which linkage protocol is in use
To establish a link between Connector and the Working Papers database:
- Save the Word or Excel document in the Working Papers file folder.
- Open the Working Papers file. From the Document Manager, locate and open the Word or Excel document.
The connection has been established between Connector and the Working Papers database.
For other possible scenarios and their limitations, where links do not explicitly reference a specific Working Papers file, refer to the following table:
Connection scenarios | Document is located inside the file folder | Document is located outside the file folder |
---|---|---|
Working Papers file is open | UDF and DDE will both connect and establish a primary (default) connection. | UDF and DDE will both connect. For UDF, you must enable Use Client File opened in Working Papers for UDFs in Tools | Options. |
Working Papers file is closed | Only UDF will connect. | Neither protocol will connect. |
Multiple Working Papers files are open |
UDF and DDE will both connect.
|
Both UDF and DDE connections may be unpredictable, although they will attempt to connect to the Active file.
Note: If Use Client File Opened in Working Papers for UDFs is enabled in Tools | Options, the linkage formula will be calculated upon opening a file. |
Notes:
- We recommend that Excel documents contain either UDF or DDE linkages exclusively, with UDF being the preferred protocol. 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.
- All Word or Excel documents calculate upon opening a Working Papers file, unless otherwise specified. If changes are made to the active file while your Word or Excel document is open, you will need to recalculate (Tools | Recalculate) to update your links.
To determine if your workstation will open Word and Excel documents with functioning Connector linkages, please refer to the following table:
Licensed software installation | UDF-based linkages | DDE-based linkages |
---|---|---|
Working Papers and Connector | Links will connect | Links will connect |
Only Working Papers | Links will not connect | Links will connect |
Only Connector | Links will not connect | Links will not connect |
If you want to share your documents with users who don't have Connector installed, you can disable the document's links while retaining link values. After disabling the links, users will be able to view the documents, but will not be able to make any updates.