AutoRefresh

Automatically refreshes all the traces in the sheet whenever you modify a formula.

To access this command...

Choose Tools - Detective - AutoRefresh.

On the Tools menu of the Tools tab, choose AutoRefresh.

Detective arrows in the document are updated under the following circumstances:

Starting Tools - Detective - Update Refresh Traces
If Tools - Detective - AutoRefresh is turned on, every time formulas are changed in the document.