Search code examples
excelhyperlinkonedrive

Hyperlinks in excel online not working

I am using these hyperlinks in an excel file in onedrive:

=HYPERLINK("C:\Users\cliff\OneDrive\CoT FMV\CoT FMV Documents\"&N2&".pdf";"View")

These hyperlinks work with no errors in the desktop version of MS Excel. I need to share this workbook and multiple users need access at the same time so Excel Online is the answer. However; when I open the workbook in Excel Online, the receive this error:

Sorry, we couldn't open this link. The link address may be invalid, or you may not have permission to open it.

I realise that C:\Users\cliff\OneDrive\CoT FMV\CoT FMV Documents\ refers to a local directory, but this is an online directory in my onedrive as well.

Solution
    1. Highlight Column or cells containing Hyperlinks
    2. On the ribbon select (insert)
    3. In the insert hyperlink box that pops up in "DisplayText" type in (Https)
    4. Select the "URL:"radio button option and type in (Https) Step 5. Click Ok. Now all ofyour hypelinks should be activated.