Option help - Again...

[Dan Wilson]

Good day. I received no responses to my last post about Option Help, so I went ahead and created a new workbook to be used for creating Random numbers involving my music library. I find now that even though all of the work being done to create 40 separate random numbers between 1 and 3009 is working, any work that I do on my other workbook causes the random numbers in the new workbook to change every time I complete a function in the other workbook. Is it possible to make an option change in the random number workbook to prevent the changes from happening while I am working in the other workbook? Any help is appreciated.
Thank you, Dan Wilson...

 

[Alex Blakenburg]

Unfortunately the random functions are volatile and will recalculate every time that instance of Excel recalculates. So if any workbook or sheet triggers a calculation all volatile functions will recalculate in all open workbooks.

You can either copy the random values as "values" to lock them in or you could see if something like the link below can help you.

Generate random numbers that don't change in Excel and Google Sheets

grid.is

 

[Dan Wilson]

Unfortunately the random functions are volatile and will recalculate every time that instance of Excel recalculates. So if any workbook or sheet triggers a calculation all volatile functions will recalculate in all open workbooks.

You can either copy the random values as "values" to lock them in or you could see if something like the link below can help you.

Generate random numbers that don't change in Excel and Google Sheets

grid.is

Good day Alex and thank you for responding. I had not thought of saving the random numbers as values. I think that will solve the problem. Once the values have been saved, it doesn't matter what happens. I saved the link and will examine that after I make the changes to save the numbers.
Dan Wilson...