Excel - SharpTrace

The Modelling group contains functions to assist with spreadsheet modelling including SharpTrace, Select Sheets and AutoColour.

SharpTrace

SharpTrace in Create allows you to navigate through any precedents or dependents of your active cell. Precedents are cells that the current cell links from, dependents are cells that rely on and use the contents of the current cell. Selecting either of these functions will open up the SharpTrace dialog which will display the cell precedents or dependents that are linked to the current cell. From the dialog you can select any of the cell precedents or dependents to go that cell. If the cell is in another workbook, Create will attempt to open that workbook. If the workbook cannot be found, Create will let you know. 

SharpTrace Precedents

To trace a cell’s precedents, select the cell containing the formula.

Select SharpTrace, SharpTrace Precedents on the Create ribbon.

In the SharpTrace dialog, you can switch between Precedents and Dependents using the icons

• The formula text box will show details of the currently selected cell.
• The Range/Function column will show the selected cell as the root item.
• Click on the arrows to expand the tree view to show the precedents items of the cell and to display their references, type, formulas and values.
• Click OK.

SharpTrace Dependents

To trace a cell’s dependents, select the cell containing the value.

Select SharpTrace, SharpTrace Dependents on the Create ribbon.

In the SharpTrace dialog, you can switch between Precedents and Dependents using the icons 

• The formula text box will show details of the currently selected cell.
• The Range/Function column will show the selected cell as the root item.
• Click on the arrows to expand the tree view to show the dependents items of the cell and to display their references, type, formulas and values.
• Click OK.