Re-Calculate randomized cells while not in active cell


I have several cells that use the RANDBETWEEN function to alter values and I would like to press F9 to re-generate new values. However, unless one of those cells is active, re-calculate does nothing. Is there an option somewhere to enable global re-calculation irrespective of which active cell I’m in?

Nevermind! Just found the answer. For those curious, it’s CTRL-SHIFT-F9

See Function "RANDBETWEEN" recalculates on every Input.

You likely use an old version, since starting with version 6.2, this has changed: see tdf#102257.