Random Function help

[Dan Wilson]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (Updated). I have a workbook with several worksheets that control my music library. One of the worksheets has formulas that generate 40 separate random numbers ranging from 1 to 3009 and with no duplicates. I have discovered that almost every time I am working with that worksheet and hit the Enter Key, the 40 selected numbers change. They also change when I activate the F9 key which they should. Is there a way to keep the random generation formula from working except when I execute the F9 key? Thank you for any help.
Dan Wilson...

 

[Joe4]

What if you shut off automated calculations and set calculation mode to manual (which you would re-calc manually with the F9 key)?

 

[Dan Wilson]

What if you shut off automated calculations and set calculation mode to manual (which you would re-calc manually with the F9 key)?

Good day Joe4 and thank you for responding. I left the automated calculations on and set the calculation mode to manual. After several experimentations and use of the Help file, I think I understand what is going on. I just have to remember to execute the Ctl-Alt-F9 before closing a workbook unless the Save option will do that. thank you again.
Dan Wilson...

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Dan Wilson]

You are welcome.
Glad I was able to help!

Ny dad was a Baptist Preacher and an Army Chaplain. That was one of his favorite sayings. Thank you.