Using excel to get a random sample of rows for quality assurance purposes.

Currently using the RAND() function in a column and then have a filter selecting those columns under 0.10 to be part of the sample. However, as the RAND() function is volatile it refreshes each time a change is made on the spreadsheet.

Currently I am copying and pasting as values to bypass this issue, but it is quite manual across several spreadsheets and would like to automate it.

Due to constraints I cannot turn off calculations or use macros. Has anyone found any workarounds or solutions to this issue?