Options help

[Dan Wilson]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (updated). I have a workbook that contains several worksheets controlling my music library. One of the worksheets is dedicated to creating forty separate, non-duplicating, random numbers between 1 and 3009. I have had a good bit of help from the Forum in creating this worksheet. The last option that I needed help with was in adjusting the Options of Excel to keep the random number formula from executing every time the Return key was used. That problem was solved by changing the Advanced, Formula setting from Automatic to Manual. That worked well until I worked on one of the other worksheets that have formulas that track the use of the songs. It took me quite a while to figure out that the Formula setting that I changed was preventing the worksheet from activating formulas controlling the use of each song. I changed the Formula setting back to Automatic and all is well except for the Random Number formulas on the other worksheet. Is there a way to solve this issue, or is it better to create the Random Number worksheet as its own Workbook with Lookup functions to access data from the other workbook and setting the Automatic Formula setting to Manual on the random number worksheet only? I appreciate any help with this
Thank you,
Dan Wilson...