This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm having trouble using the Hyperlink function in Excel (Office 365) to link to files on my local drive. Http links are working fine.
The only guidance I can find for format for a Mac online is:
=HYPERLINK("Macintosh HD:Budget Reports:First Quarter", "Click here")
But I've tried every combination of ":","" and "/" I can reasonably think of and can't access any file on my drive, regardless of how I've set the permissions. I get the same error message "Cannot open the specified file" regardless of the formatting.
I've got a lot of files I'd like to hyperlink and don't fancy going through the whole lot with cmd-K and then clicking through the file browser when I could write a script to generate the formatted links with this function very easily.
Any suggestions on the format? Or does this no longer work under MacOS?
Thanks for any guidance.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
It is reported that HYPERLINK did work on Yosemite but not working on High Sierra for local files. If you have High Sierra, it won't work.
This has been reported to Microsoft by various people and a fix may be in the offing in coming versions.
Many thanks! That clears it up then - I do indeed have High Sierra so I'll drop this attempt for the time being.
Look forward to a fix though - hopefully it will be flagged up somewhere so I know when it's worth picking this up again.
Thanks Carlos. I'd come across this page in my searches.
However, it gives plenty of examples of URLs and Windows paths, but nothing related to the Mac as far as I can see. I've only found that one example with a Mac path (using the colons) and it doesn't work for me. As I say, linking to a remote site by http works fine so it's not the function. And I've set permissions on the file as low as possible so I don't think it's that.
Either it doesn't work for files on a Mac anymore, or I've got the path syntax wrong and can't find an example of the correct version or work it out by trial and error.