Forum Discussion

abi21gail's avatar
abi21gail
Copper Contributor
Oct 06, 2023

Hyperlink unable to open

Hi! I inserted a dropbox link on my file, but the receiver of the file can't open the said link.
But on my side there is no issue. Anyone can help me pls?

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    abi21gail 

    Office apps have had trouble with direct links to network or internet files since at least Office 2003 (Maybe even before then).  Direct links to tend to break.

     

    First, you'll want to verify the drop box link works outside of Excel.  If it does, you can try one of these then rebuild the hyperlink.

     

    1. Disable 'update links on save' (anyone using the workbook can disable it):

     

    2. Create a hyperlink base in the workbook properties. This is a bit more involving and only an option if dropbox is the only type of link in the workbook.

  • Zeelmaekers's avatar
    Zeelmaekers
    Copper Contributor
    Hey Abigail,

    Normally opening links in an Excel file shouldn't be an issue, but it can be when the path to where they link is not public. Check your Dropbox share options if everyone can access that file or if the file is private, this will probably be the issue.
    • abi21gail's avatar
      abi21gail
      Copper Contributor

      Zeelmaekers hi! the dropbox link is available for viewing. I'm kinda confused whether the issues is from the excel or the dropbox

      • Zeelmaekers's avatar
        Zeelmaekers
        Copper Contributor

        Hey abi21gail 

         

        It's hard to say with this little information maybe you can request more information from the receiver. Can you open the link in an incognito tab (Ctrl+shift+n for most browsers) and check if you are able to view the content if you are able to. I don't think there is an issue with the link.

    • abi21gail's avatar
      abi21gail
      Copper Contributor

      HansVogelaar 

       

      I just copy the link of the dropbox file and paste it directly in the address bar as shown on the picture

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        abi21gail 

        Did you do it this way?

        Activate File Explorer.

        Locate the file in your Dropbox folder or one of its subfolders.

        Right-click the file.

        Select Dropbox > Copy Dropbox link from the context menu.

        Switch to Excel.

        Insert > Link.

        Paste the link into the Address box (Ctrl+V).

Resources