Announcements
Known issues updated. Learn more

default

no

Highlighted

Using hyperlinks in Excel to connect to files uploaded in dropbox

New member | Level 2

Wondering if there is a way to create a spreadsheet, with hyperlinks to specific files that are uploaded on dropbox.  (hyperlink was created by going into dropbox, displaying specific file, copying address and creating hyperlink in spreadsheet).  Files do not reside on my computer - only on dropbox.  The specific people who receive the Excel file already have access to (files shared) said files on dropbox.

 

Tags (1)
3 Replies

Re: Using hyperlinks in Excel to connect to files uploaded in dropbox

Dropboxer
Hey there @GRRWendy,
 
Currently there isn’t a way to do this automatically, you would need to create the Excel file and then enter the hyperlinks into the file manually.
 
From what I understood you are copying the URL address into the Excel file, correct? That will work fine since the people who will be accessing the files already have the files shared with them. I just wanted to mention that you could also use shared links as the hyperlinks if you need to share anything with view only access (providing the file isn’t already shared with edit permissions for the recipients).
 
Hope this helps to clarify the matter - Thanks!



Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below. 
White check mark Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.
Arrows Counter Clock Still stuck? Ask me a question! 

Reply
Loading...

Re: Using hyperlinks in Excel to connect to files uploaded in dropbox

New member | Level 2

Hey Daphne, I'm not sure I understand - I DID create an excel file and I DID insert hyperlinks to the displayed page in dropbox... I emailed the spreadsheet to the people who needed to access said hyperlinks but they were unable to access the files directly - the link took them to dropbox sign in page.  The goal of this is to, in one spreadsheet, with 40 categories (columns) and varying documents for each of 35 applicants, all at varying stages of completion - to see/access the files that have been submitted - so in addition to making it easier to access the files, the spreadsheet gives us information on where everyone is in the process... so I'm trying to do more than "just share files" - hope this helps explain how it is that I'm trying to use dropbox and why slightly smiling face

Reply
Loading...

Re: Using hyperlinks in Excel to connect to files uploaded in dropbox

Dropboxer
 
Thanks for that clarification there, it seems that I didn’t fully understand there!
 
So, in this case I would recommend creating a shared link instead of adding the URL hyperlink into the Excel file. If those who are trying to access the file are not signed into a Dropbox account or don’t have the file actually shared with them, then a shared link will allow them view access to the files.
 
If you are using just the URL of the file as the hyperlink, since this is pointing towards a file within your account, the hyperlink can only be used to access the file when signed into your Dropbox account. Using shared links will eliminate this issue.
 
Let me know if this clears thing up a bit  - Thanks!



Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below. 
White check mark Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.
Arrows Counter Clock Still stuck? Ask me a question! 

Reply
Loading...
Syncing and uploads

Have a question? Our Dropbox Community is here to help!

Post your question or search for an answer below.


Learn more about using the Community by reading our Community Guidelines.


Hi anonymous,

If you need more help you can log a ticket with our Support Team here (expected response time 24 hours), or contact us on Twitter or Facebook.

For more info on available support options, see this article.

If you found the answer to your question, please 'like' the post to say thanks to the user!

Using hyperlinks in Excel to connect to files uploaded in dropbox
214 Views
3 Replies
0 Likes
Who's talking
Top contributors to this post