Hi Folks,

How to generate file sharing links with read only permission at large scale in excel spreadsheet?

I have a spreadsheet which contains a bunch of hyperlinks to local files. I can review these images by clicking on the hyperlink then open a dialog box like this SecurityNotice.PNG. After click "Yes", computer will open image viewer software to open this file.

After I moved all my files into OneDrive & sharing the spreadsheet with a link. My friend who has the link cannot view those image files because these files are not in their local OneDrive folder.

I am thinking of replacing the hyperlink with a sharing link of the image with view only permission. Of course I can do it one by one. But I have about 1000+ images. Is there a way to do it with Excel functions?

Thank you!


Best Regards,
David WANG