You can insert XL3Link formulas directly into the spreadsheet using the Anaplan XL > Insert Formula > XL3Link ribbon or menu option.

To insert an XL3Link:

  1. Select the cell to insert the link in.
  2. Select the Anaplan XL > Insert Formula > XL3Link ribbon or menu option.
  3. Choose a location to jump to when the link is selected.
  4. Enter the text to display in the link.
  5. Select OK to insert the formula.

The Link type can be either a Hyperlink (underlined and activated by a single click) or a Double-click link (the link activates when the cell is double-clicked).

Other cells can be updated when the XL3Link is activated. The XL3Link formula reference has more details.