How do I send a document to an external reviewer if they do not have Connector

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 ordinary Word or Excel document. If changes are made to the Working Papers client file, they will not be reflected in an unlinked document.

This function is useful for third-party distribution as it allows for viewing a Connector document on a workstation that does not have Connector installed.

Note: In Excel, this operation applies to all worksheets in the workbook.

Prerequisites

In certain cases this operation is not possible or can result in an unlink that is permanent (you will not be able to re-link).

If applicable, ensure to create a backup copy of your document prior to unlinking.

Unlinking DDE links in Word is permanent. You cannot re-link.

If the workbook structure is protected (meaning new sheets cannot be added), an unlink is permanent.

If the worksheet is protected, locked cells cannot be unlinked, even when the workbook structure is protected.

Procedure

1. From the Connector toolbar, click Tools | Unlink.

2. A prompt appears for confirmation.

3. Click Yes to continue.

Result

Once the process is complete, the most recent values returned by the links will remain in the document, but the links themselves are severed.

 Make sure you save your document after verifying all changes.


Notes
To correctly relink the document to the client file at a later date, ensure that:

- Worksheets are not renamed. Connector uses the worksheet name as a basis for restoring the links.

- Excel documents maintain their original structure at the time of unlinking. If rows and columns are deleted prior to relinking, Connector will be unable to restore the formulas unless Connector, Working Papers, and the client file are accessible.


    • Related Articles

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

    • How to insert an External Section & Document into the Financial Statements?

      External documents such as Microsoft Word or PDF Documents can be inserted into your Financial Statements for added reference or for different sections in your Financial Statements. External documents can also have its own separate financial ...

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

    • Replace external documents in Agile Audit

      You can replace external documents, such as PDFs, Word files and Excel files, that you have previously uploaded to the engagement. Note: Document versioning is not supported (no version history is retained). To replace an external document: 1. From ...