|
|
|
|
#1
11-10-2016, 03:52 PM
|
||||
|
||||
Anything that causes a workbook to recalculate with cause the RAND function to do exactly that - recalculate. The only way of preventing the RAND variables recalculating them is to copy/paste their outputs as values - which then removes the formula and its RAND behaviour.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Combine documents makes duplicate word
|
vincelge | Word | 2 | 05-15-2017 05:47 AM |
|
Windows Explorer makes folders read-only without warning or explanation
|
RBLampert | Windows | 3 | 06-25-2015 02:45 AM |
|
Section break makes style change when printing or saving as pdf
|
bohk | Word | 4 | 06-07-2013 02:34 PM |
|
How do I create an object, that when clicked makes a sound?
|
netrate | PowerPoint | 1 | 01-02-2013 12:02 AM |
| word 2007 makes my computer restart by itself without err ms | ambertexas | Word | 0 | 02-11-2008 06:35 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode