We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. Learn more here.
Forum Discussion
Sharing links in Excel spreadsheet - opens dropbox but not link
Hi I hope someone can help with this probably simple problem. I have an excel spreadsheet that I want to share links to documents with. I find my document in dropbox, right click, share link get the ...
I have another way of doing this, and this assumes that the Excel file you have is actually within the Dropbox structure somewhere (which is a reasonable assumption).
So simply create a hyperlink (Ctrl + K) within the cell in Excel and select the file you want to hyperlink to. Excel actually stores this as a RELATIVE path to that file, so even if someone else clicks that link it will open correctly. Here is the example:
Your Excel file is in "C:\Users\Katherine\Dropbox\Excel\MyFile.xlsx" and you want to link to "C:\Users\Katherine\Dropbox\Attachments\MyLinkedFile.docx".
So you hit Ctrl + K and use your filing system to find MyLinkedFile.docx. What happens is that Excel will store the link as "..\Attachments\MyLinkedFile.docx".
If you then tell Bill to open the Excel file and he clicks it, the relative link will correctly find "C:\Users\Bill\Dropbox\Excel\MyFile.xlsx" - in fact it won't matter where Dropbox is stored it will always work.
Hope that helps,
Phil
