You are here: Help Topics > Connector Linkages > Modifying Links > Relinking Formulas [Excel Only]

Relinking Connector Formulas [Excel Only]

After unlinking a document for external use, you can re-establish links in the document using the Relink function. This function replaces the static values from an unlinked document with their appropriate Connector formulas.

Note: This operation only applies to Excel.

Prerequisites

Use the original name for your worksheets at the time of unlinking. Relink will fail if the worksheet was renamed between these operations.
Ensure that the Excel document maintains its 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.

Procedure

From the Connector toolbar, click Tools | Relink.
Click Yes when prompted.
Ensure cells contain Connector formulas instead of static values.

Results

After performing this operation, the value for each cell is replaced by its corresponding Connector formula. Perform a Recalculation to ensure all values are up-to-date.

Make sure you save your document after verifying all changes.