Linking to Account Spreadsheets

You can link data in worksheet cells directly to the Account spreadsheet for use in financial models. When you are viewing the cells on the Account Spreadsheet, cells that include data linked from a worksheet are highlighted in green.

To link data from worksheet to the Account spreadsheet:

  1. Select a worksheet.
  2. In the worksheet, highlight a cell or range of cells.
  3. From Start grouping label, click WorkSheet, then Copy Worksheet Link.
  4. Select the Account spreadsheet.
  5. In the Account spreadsheet, highlight a cell or range of cells.
  6. Select Edit, then Paste Worksheet Link.