rand keeps generating new random number

**healing** · 03-07-2013, 12:59 PM

Hi,

I am using rand to produce a column of numbers in woorksheet 1

=(COS(RADIANS(RANDBETWEEN(0,360))))*(1/$C$27)

in worksheet 2 i have this in a column that copies the contents of the column in worksheet 1

=worksheet1l!AB8
=worksheet1l!AB9
.
.
.
.

Anytime i do an operation to the column in worksheet 2 new random numbers are generated, which i dont want

is there someway i can get them to generate on command only?

**tgsekhar** · 03-07-2013, 01:03 PM

Any Function will undergo a recalculation whenever changes are made to workbook. Rand will keep changing values as the purpose of Rand is to provide a random value. Execute a Copy -> Paste Special - Values to make the formula into a value to solve your problem

**ChemistB** · 03-07-2013, 01:04 PM

Yes, you can set your workbook to do manual calculation. Formula calculations will only occur when opening the workbook or when you enter a new formula or tell it to calculate (F9)
On File Tab> Options> Formulas >Set Workbook Calculation to Manual

Alternately, Copy and paste special > values to make the rand values constants. You'd need to retype in the formulas to do a new set of rand values though.
Does that help?