Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

AutoRefresh

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

To access this command...

Choose Tools - Detective - 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 formulae are changed in the document.