Can someone tell me what the Rand() function in the FormulaBuilder is meant to do? A user discovered that when he uses the function it inevitably brings down the application. It appears that it calculates a decimal between 0 and 1. I would think it would do this once per row. However, it calculates each row over and over constantly regenerating which takes up 50% of the cpu and eventually freezes up the app from accepting input.
The RandBetween appears to regenerate each row's value a few times before eventually staying static and not hosing the application.
Thanks in advance.
The Rand function generates a new value any time the function is recalculated for any reason.
The CalcManager is optimized so that it only recalculates a function when something has changed. So if you are using Rand in a cell formula, then some other value reference in that formula must be changing if things are being recalculated continuously.
Any good way to verify what value reference is changing? I literally just add the formula and sit back and watch it continually recalculate without interacting with the application at all. Is there any chance that the values in other cells being calculated for the random number could trigger the change?