Recalculate Hard

Recalculates all formulas in the document, including Add-In functions and non-volatile functions.

āĻāĻ‡ āĻ¨āĻŋāĻ°ā§āĻĻā§‡āĻļāĻžāĻŦāĻ˛ā§€āĻ¤ā§‡ āĻ¸āĻ¨ā§āĻ¨āĻŋāĻŦā§‡āĻļ āĻ•āĻ°āĻ¤ā§‡...

From the menu bar:

Choose Data - Calculate - Recalculate hard.

From the keyboard:

+ Shift + F9


The Recalculate Hard command forces recalculation of all formula cells of the spreadsheet document, including explicit non-volatile functions, even if no new input event exist. Examples of explicit non-volatile functions are RAND.NV and RANDBETWEEN.NV.

Please support us!