how to stop the rand() function

  • Thread starter Thread starter mytrixs
  • Start date Start date
M

mytrixs

how to stop the rand() function from recalculating every
time changes are made. further, how is data held as statci
in excel
 
RAND() is a volatile function. You can select the range,
copy it, and then do paste special > value.

HTH
Jason
Atlanta, GA
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Repeating a RAND() function under certain conditions 0
RAND() 9
How to get repeatable Excel RAND sequence? 12
Rand() formula 14
Questions about RAND() function 2
reffering another cell value which contains RAND() 0
What does Excel's RAND function really do 0
What does Excel's RAND function really do 4

Back
Top