Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Don't want to constantly update Random numbers
Hi, I have a worksheet with thousands of random numbers being generated. But
it takes a while for all the boxes/formulas to update every time I change a single box in the worksheet. Can I somehow force it to NOT UPDATE these random numbers every time? Besides, I'd prefer if the numbers would not change, because then I have to adjust my plots every time they update. It would be more convenient if all my random numbers just stayed the same from now on. Can I do this? Thanks, ApeMan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Don't want to constantly update Random numbers
1. - simply translate ur formula to valus
or 2. - set calculation to manual then run: Sub myCalc() Range("A20:A40").Calculate ' change to what range u want End Sub "ApeMan" skrev: Hi, I have a worksheet with thousands of random numbers being generated. But it takes a while for all the boxes/formulas to update every time I change a single box in the worksheet. Can I somehow force it to NOT UPDATE these random numbers every time? Besides, I'd prefer if the numbers would not change, because then I have to adjust my plots every time they update. It would be more convenient if all my random numbers just stayed the same from now on. Can I do this? Thanks, ApeMan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Don't want to constantly update Random numbers
Select and Copy the range
Then Use Edit | Paste Special - Values to convert formulas to values best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ApeMan" wrote in message ... Hi, I have a worksheet with thousands of random numbers being generated. But it takes a while for all the boxes/formulas to update every time I change a single box in the worksheet. Can I somehow force it to NOT UPDATE these random numbers every time? Besides, I'd prefer if the numbers would not change, because then I have to adjust my plots every time they update. It would be more convenient if all my random numbers just stayed the same from now on. Can I do this? Thanks, ApeMan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
generate unique random numbers | New Users to Excel | |||
generate random numbers | Excel Worksheet Functions |