New challenge, I've got a spreadsheet that people shouldn't have general access to so it is stored in a folder on Onedrive with limited permissions. However, I do want to create a spreadsheet that links to it that anyone can refresh. I need to double check but I think this fails on refresh from when I tried to do it before. Any tips?
Yep, macro seemed to be the option.
New challenge, I've got a spreadsheet that people shouldn't have general access to so it is stored in a folder on Onedrive with limited permissions. However, I do want to create a spreadsheet that links to it that anyone can refresh. I need to double check but I think this fails on refresh from when I tried to do it before. Any tips?