Calculation Tool Command

Use the calculation tool to identify cell dependencies throughout the document. The dialog displays a selected cell and the hierarchical listing other cells in the document dependent upon it or its calculation. This listing looks very similar to the listings of folders and their contents in Windows Explorer in that branches of interrelated cells may be expanded and collapsed. Click Expand to expand the hierarchy of cell dependencies and click Collapse to collapse a dependency path.

To access the Calculation Tool, on the Tools tab, click Calculation Tool.

Symbol	Means
	Dependency involves the cell number.
	Dependency involves the cell group.
	Dependency involves a relative reference to the cell, for example R(-3).
	Dependency involves a cyclic calculation. Using this display, it is easy to identify circular dependencies that need correction.
	Dependency involves a summation.
	Dependency involves a custom property.

To get a complete understanding of a particular cell dependency, it is possible to jump to referenced cells directly from the dialog.

Dependency Path

Displays the path linking the highlighted cell back to the parent cell using an alphanumeric reference.

Used By

Displays the numbers of cells containing the highlighted cell in their calculations.

Calculation

Displays the calculation entered in the highlighted cell. If the dependency is part of an event, the calculation does not display.

Note: Click Calculation to open the Calculation Explorer window.

Show Cells

Select this option to display all calculated cells.

Show Groups

Select this option to display all calculated cell groups.

Jump

Click Jump to locate the selected cell in the document.

Collapse

Click Collapse to collapse the dependency path for the cell.

Expand

Click Expand to expand the dependency path for the cell.

Collapse All

Click Collapse all to collapse dependency paths for all the cells shown in the listing.

Expand All

Click Expand all to expand dependency paths for all the cells shown in the listing.