You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.
  • 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?

  • This is asking for trouble. I would split the public data out into a public spreadsheet.

    If it needs to be updated from private data, automate that under a privileged account.

    Edit: I have no idea how to do this in OneDrive, TBH

About

Avatar for chez_jay @chez_jay started