Forum Discussion
abi21gail
Oct 06, 2023Copper Contributor
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?
- Patrick2788Silver Contributor
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.
- ZeelmaekersCopper ContributorHey 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.- abi21gailCopper Contributor
Zeelmaekers hi! the dropbox link is available for viewing. I'm kinda confused whether the issues is from the excel or the dropbox
- ZeelmaekersCopper 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.
How did you create the link?
- abi21gailCopper Contributor
I just copy the link of the dropbox file and paste it directly in the address bar as shown on the picture
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).