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.

निम्न परिस्थिति में दस्तावेज़ में डिटेक्टिव तीर अद्यतन होते हैं:

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