From LibreOffice Help
Jump to: navigation, search

Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.

Choose Tools - Cell Contents - Recalculate


Press F9 to recalculate. Press Shift+Ctrl+F9 to recalculate all formulas in the document.

After the document has been recalculated, the display is refreshed. All charts are also refreshed.

The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+Ctrl+F9 to recalculate all formulas, including the Add-In functions.