Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

dodomolinari's avatar
dodomolinari
Explorer | Level 3
6 years ago

Link to a cell in a different Excel file saved in Dropbox

Hello everyone.   I am trying to link the value of a cell in an Excel file saved in a Dropbox folder to another cell in another Excel file saved in another Dropbox folder. Is there any way I can ...
Microsoft Office
Organize
sort
sync
Lusil's avatar
Lusil
Icon for Dropbox Staff rankDropbox Staff
6 years ago

Hey dodomolinari, thanks for reaching out to us.

 

You're right, when you create such a link, it's looking for a specific location on your hard drive.

 

So when you open it from another computer and the path is different, the workbook isn't able to run accordingly. 

 

You can find some additional information on this given by Walter, here. 

 

Check it out and let me know if you have any other questions. Cheers!

dodomolinari's avatar
dodomolinari
Explorer | Level 3
6 years ago
Thank you Lusil. I read the article but it is still not clear to me whether I can do this or not. Can I somehow link the value in a cell to the value in another cell in another file, both on Dropbox? And can I update those values from different devices that share the same Dropbox folder?

Thanks for your help.

Edoardo.
  • Daphne's avatar
    Daphne
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    6 years ago

    There isn't a limitation from Dropbox that would prevent you from doing this dodomolinari.

     

    Please just bear in mind that in doing this, if you reference a file with the file path "C:\Daphne\Dropbox\Folder\File", that the hyperlink added into the Excel cell will only work when using the local Excel app on your computer.

     

    If you were to open the file online with the Excel Online integration, it can't read the local file path and would give an error in the cell.

     

    Similarly, if you use Dropbox on another computer, the username might be different. So, the filepath to the file you want to link would instead be "C:\Edoardo\Dropbox\Folder\File", for example.

     

    I hope this helps to explain the situation a little better!

    • dodomolinari's avatar
      dodomolinari
      Explorer | Level 3
      6 years ago

      Thank you Daphne. It sounds like I cannot then use the same link if I want the file to be working from different locations but I need to update the value manually.

About Delete, edit, and organize

Solve issues with deleting, editing, and organizing files and folders in your Dropbox account with support from the Dropbox Community.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!