SOLVED

Generate random values every time a student opens file

%3CLINGO-SUB%20id%3D%22lingo-sub-2330484%22%20slang%3D%22en-US%22%3EGenerate%20random%20values%20every%20time%20a%20student%20opens%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330484%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20SS%20that%20students%20are%20using%20to%20collect%20and%20then%20analyze%20data.%20Due%20to%20the%20pandemic%2C%20they're%20not%20able%20to%20actually%20collect%20as%20much%20data%20as%20I%20would%20like.%20So%20I%20would%20like%20the%20SS%20to%20be%20prepopulated%20with%20some%20data%2C%20but%20with%20different%2C%20randomly%20selected%20data%2C%20for%20each%20student.%20How%20can%20I%20design%20the%20SS%20so%20that%20each%20time%20it's%20downloaded%20and%20opened%20by%20a%20student%2C%20a%20different%20set%20of%20data%20Is%20prepopulated%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2330674%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20random%20values%20every%20time%20a%20student%20opens%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035984%22%20target%3D%22_blank%22%3E%40Ted_W1855%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETake%20a%20look%20at%20%3CA%20href%3D%22https%3A%2F%2Feileenslounge.com%2Fviewtopic.php%3Fp%3D160305%23p160305%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEileen's%20Free%20Random%20Data%20Generator%20for%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332197%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20random%20values%20every%20time%20a%20student%20opens%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332197%22%20slang%3D%22en-US%22%3EThanks%20a%20million!%3C%2FLINGO-BODY%3E
New Contributor

I have a SS that students are using to collect and then analyze data. Due to the pandemic, they're not able to actually collect as much data as I would like. So I would like the SS to be prepopulated with some data, but with different, randomly selected data, for each student. How can I design the SS so that each time it's downloaded and opened by a student, a different set of data Is prepopulated?

2 Replies
best response confirmed by Ted_W1855 (New Contributor)
Thanks a million!