Prevent sheet from recalculating RAND(),

[excel?]

I need to prevent my sheet from constantly recalculating the RAND() function on the sheet any time I do something.

I tried to change the Calculation Options to manual, but that was for Excel and not my specific sheet.

My Sheet, Cases (2), has multiple RAND() functions but once I generate the numbers I need it to stay the same until I need to regenerate them.

How do I turn off Automatic Calculation for this sheet only so I can do other things on this sheet, enter data and use formulas on other sheets and open/close the file without changing the numbers until I need a new set of numbers generated?

Thanks

 

[kweaver]

I think you'd have to select those RAND values and do a "paste special values". That won't, unfortunately, enable you generate a new set of RAND values.
I'm guessing you'd have to set the cells that use RAND within a macro to then reset them and paste the values again.

 

[sandy666]

I don't know structure of your data and where RAND() is but maybe you can use TimeStamp for RAND(), eg.

[B][COLOR="#0000FF"]B2:[/COLOR][/B] =IF(A2="","",IF(B2="",RAND(),B2))

with iteration enabled