cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Check out the Dropbox cheat sheet for getting started in 2021 here!

Dropbox files & folders

Get in sync with the Dropbox Community. Our members can answer all your questions on Dropbox files and folders. Join a discussion or start your own today.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

Explorer | Level 3

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 do this and have it working from different locations? To explain it better, cell A1 in File1.xls needs to look up the value of cell C2 in File 2.xls, but File1.xls and File2.xls are both saved in Dropbox.

 

The problem I have is that I need those values to be accessible and updated automatically from any device I use with Dropbox and by different users who have access to those folders. However, if I am working on those files from my MacBook, when I open the file on my iPhone using Dropbox and Excel apps, it says that there is an external link and it cannot be updated.

 

Thanks for your help!

4 Replies 4

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

Dropboxer

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!


Lusil
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

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

Explorer | Level 3
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.

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

Dropboxer

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:confused face: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:confused face:Edoardo\Dropbox\Folder\File", for example.

 

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


Daphne
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

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

Explorer | Level 3

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.

Polls
Are you starting new work habits this year?

Work Smarter with Dropbox

The way we work is changing. Share and discover new ways to work smarter with Dropbox in our community.

Sound good? Let's get started.
Who's talking

Top contributors to this post

What do Dropbox user levels mean?
Need more support?