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
Feb 10, 2018 Excel for Mac 16.9, Mac OS 10.13.3: Excel hyperlink to trusted pdf files located in the same folder as worksheet open after virus warning when link is first established, but later gives 'cannot open the specified file' alert after quitting and relaunching excel. Insert> Object will not work in Excel, although it does work in Word but produces the same net result as the Insert> Photo method. As an alternative you may want to Hyperlink a cell to the PDF file or create a Shape to use as a 'button' which can be Hyperlinked to the PDF.
=HYPERLINK(A1)
where A column has the path to the file names (e.g., /Users/kestrel/Desktop/photos/a.jpg)
Free Excel For Mac 2018
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!
2 Answers
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!
Try using:
Note the backslashes ( - Windows path delimiter) instead of forward slashes (/ - Mac, Linux, Unix path delimiter).
Microsoft Excel For Mac 2018
Works consistently for me on Excel v 15.29.1 on Mac.