M mytrixs Mar 19, 2004 #1 how to stop the rand() function from recalculating every time changes are made. further, how is data held as statci in excel
how to stop the rand() function from recalculating every time changes are made. further, how is data held as statci in excel
J Jason Morin Mar 19, 2004 #2 RAND() is a volatile function. You can select the range, copy it, and then do paste special > value. HTH Jason Atlanta, GA
RAND() is a volatile function. You can select the range, copy it, and then do paste special > value. HTH Jason Atlanta, GA
A Arvi Laanemets Mar 19, 2004 #3 Hi Copy the cell PasteSpecial.Values Or, when you want to preserve the formula, you can set calculation to manual (Tools.Options.Calculation). Then formulas are calculated only, when you press F9. But it means, other formulas too doesn't recalculate automatically anymore.
Hi Copy the cell PasteSpecial.Values Or, when you want to preserve the formula, you can set calculation to manual (Tools.Options.Calculation). Then formulas are calculated only, when you press F9. But it means, other formulas too doesn't recalculate automatically anymore.
