Problem with =HYPERLINK on mac

Question

Hi guys,

I'm working on Mac - 10.11.6.

Excel16 - version 15.28 &

Excel11 - version 14.6.2

so my aim is to have a Excel-sheet inside a folder. In this folder is another folder with ~800 audiofiles.

I created a .xlsx with alle names of the audiofiles. I did this with Excel11 because I thought the 2016 version could handle older versions.

I used a function (=HYPERLINK("folderWithAudiofiles/"&A1&".wav";"Audifile") - A1 is the name of my audiofile which i get from each cell - so in the end I just expand my formular on all cells. It worked. I tried to do the same in Excel16. The "=HYPERLINK" was replaced by "=LINK" and It didn't work. I'm missing the HYPERLINK function (Excel16 doesnt't even show it's name as a proposal).

So my question is:

could anyone please help me to solve this problem.

Is there a workaround, so my .xlsx file works on both versions?

(I think that this shouldn't be a problem, but I can't help myselfe to make it work)

Thanks for your help

Anne : )

Answer 1

When you see the drop-down and Hyperlink is highlighted, press the TAB key to insert the commend into the cell.

Answer 2

Hi Anne,

Are there any updates? Can you find the Hyperlink function now?

Regards,

Tim

Answer 3

Hi Anne,

You can click Insert>Functions in the top bar, search for HYPERLINK. If it cannot get the result for this function, you may update Office 2016 for Mac to the latest version. Check if this functions appears.

Moreover, let your friends check if they can find this function on their Macs. We can know if the issue is only related Excel on your Mac.

For the link_location, based on my test, we can directly use the path in your post if the Excel file and audio files are in the same folder.

Best regards,

Tim

Answer 4

Hi Tim,

thanks for your answer.

Saidly I'm not able to "choose HYPERLINK".

If I'd use the detailed path, my folder would not be moveable to other systems e.g. a friends computer?!

Best

Anne : )

Answer 5

Hi Anne,

In Excel 2016 for Mac, you should still use =HYPERLINK for hyperlink function. Meanwhile, we use “,” between link location and friendly name instead of “;”.

Moreover, if "folderWithAudiofiles/"&A1&".wav” doesn’t work, please change it to the detailed path. You can select the file, click Command + Ito get the path, copy it into the formula, and then check if there are some improvements. To learn more, see HYPERLINK function.

Best regards,

Tim