Hi,

RANDBETWEEN is a volatile function, like TODAY and NOW among others, that
means they recalculate whenever the spreadsheet recalculates. You have a
couple of solutions.

In addition, since you must have the Analysis ToolPak installed (2003 or
earlier) to be using this function, you could also use the command Tools,
Data Analysis, Random Number Generation. There are a number of different
distributions you can use and for your purposes the output are hard numbers
not formulas.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"kjetil syvertsen" wrote:

i have used randbetween funtion to generate a series of numbers. I now want
to work with these numbers trying out different ideas I have. But every time
i make a change to ANY cell in the whole workbook the randbetween fct runs
and changes the whole series . How can I get by this problem.