Various worksheets allow you to inspect a balances calculation or go directly to the source worksheet.
This allows you to identify the origin of a figure link from another worksheet easily.
To use this function, click on the blue arrow located next to a figure in a worksheet.
Depending on the balance, there may a number of worksheets linked making up the resultant balance:
- No worksheets: If no worksheet has been inserted into the file which the amount relies on, then a blank pop-up box will appear.
- One worksheet: If there is just one worksheet in relation to the amount, clicking on the arrow will take you to the amount and show you which worksheet the amount originated from.
- Multiple worksheets: If there are multiple worksheets in relation to the amount, a popup will appear and show you what the amount is comprised of. On this popup, you will have the option to go to the worksheet.