I'm using Microsoft Excel (Version 15.33) on Mac and try to insert hyperlinks for images stored locally. The hyperlink function doesn't work whether I do
=HYPERLINK("/Users/kestrel/Desktop/photos/a.jpg")
or
=HYPERLINK(A1)
where A column has the path to the file names (e.g., /Users/kestrel/Desktop/photos/a.jpg)
I'm positive those paths are correct, because those links work on previous Mac Excel versions. Can this be due to the new Excel version or can someone please suggest another way for mass inserting hyperlinks in this version please?
Thanks!
I've found that I have to grant permission to the parent folder (in a roundabout way) that the files I'm trying to link to are in in order for my hyperlinks to work. I'll do my best to explain.
I just go to an empty cell, control-click and select HYPERLINK. Click select to navigate to the file I want to link to since it won't let me just select a folder. Then I delete the file name (and any subfolders, if necessary) in the path until the path is only to the parent folder that contains my files. (I've found you can go far back on this if you need to, if files are stored in folders all over the place.) Then click OK and it will insert the hyperlink to that folder in the cell. Click the link, and a Grant File Access window pops up, click Select... navigate back to your parent folder and click Grant Access. Then the security window pops up, click yes and the folder opens. Now all the links I insert via the path name in that folder work.
This has worked for me on a few different spreadsheets with files in different drives and it is the best solution I could find so far, through trial and error. Hope it helps someone!