Sharing links in Excel spreadsheet - opens dropbox but not link

Hi again :)

If they work pasted in emails etc. then it isnt a Dropbox issue..... annoyingly it sounds like Excel is 'tweaking' them and doing something to the data. No idea what that is however!

One quick thing to check is that when you are using the links in Excel that Excel is told they are web links (so it is treating them as HTTP and not trying to open a folder on your machine). 

The most simple way around all this is to make the hyperlink link to the file where it is stored online in your Dropbox through the "https://www.dropbox.com/filename" link. You can get this link online or by clicking the right mouse button on the file stored on your computer and clicking "Copy Dropbox Link".

Working so far for me. 

Hi Kat, 

That will not work when you send the document, that link will only remain live to you on your own drop box on your PC, not externally.

I've found the correct way, try typing this in your cell: 

=HYPERLINK("copy and paste your drop box link here","type the name of the file you want to call it here")

if i want to share a estimate which is a PDF file, it will look like this:

=HYPERLINK("https://www.dropbox.com/s/blah020/blah020/blah020/blah020.pdf?dl=0","Estimate Number 1")

Good luck

Lea 

Well done Lea!  I think you've cracked it.  This is indirect, but it does work.

Thank you.

Susan

:) 

Good point Lea, I was having the problem with shared dropbox folders.

I wonder if you get around that problem by getting the dropbox file's share link (share file to people who have the link), and then just copy that into the Excel hyperlink box?

Same Issue.

Excel file + Hyperlink in sheet = Open excel file on browser.

Issue= Not easy to open hyperlink from excel sheet.

           Want the link to be open on single click.

Any solution please...

Amit, mine do open on a single click.

Hello all; I have set up a spreadsheet of nominations where each record has a hyperlink to suppporting documents. (I used Insert hyperlink and all the documents are in the same dropbox folder as the excel workbook) The aim is to share this with the judges so that they can all read the material. I shared a link but when I tested it, the hyperlinks didn't work. 

The links wont work Barbara because as has been said the links are for your specific machine only. As soon as you are not on your machine the links are broken and so wont work. 

You need to use a different way to link the things together I'm afraid. 

Maybe used Shared Links?