Re-Calculate randomized cells while not in active cell

English
, ,
#1

Hi

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?

#2

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

#3

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.

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.