Hotlinking Data

Hotlinking enables imports data from external sources.

  To hotlink data:

  1. In an external spreadsheet, select a cell or range of cells.

  2. Copy the cells.

  3. In Strategic Finance, select Accounts and select the initial cell where the data should link.

    Note:

    Do not select ranges containing calculated values or deactivated accounts—the range should only contain cells accepting inputs.

  4. Select Edit, then Paste Special.

  5. On Paste Special, select Paste Link.

  6. Click OK.

    Hotlinked cells display with a blue background.

    Note:

    Applications that put currency symbols such as US $ in the source cell are interpreted as n/a. To ensure the integrity of linked values, use the general or comma number format in the source spreadsheet.