cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Want to learn some quick and useful tips to make your day easier? Check out how Calvin uses Replay to get feedback from other teams at Dropbox here.

Create, upload, and share

Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.

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

Problems with linking Excel files in Dropbox for Business

Problems with linking Excel files in Dropbox for Business

HRO
New member | Level 2
Go to solution

Hi,

 

We have just changed from local fileserver to Dropbox for Business, and have now ran into trouble with linked Excel documents.

I want to fetch and display values of a certain cells in one excel document on Dropbox into another excel document on dropbox. The problem now being that the reference is made to the file version stored locally on the PC's, not the masterdocument on Dropbox. This means that the link becomes user depenant (works only for the one who creates the link).

 

More of a excel challange maybe, but I cannot seem to insert a relative address or a use the for cell lookup. Any suggestions?

 

1 Accepted Solution

Accepted Solutions

Rich
Super User II
Go to solution

HRO wrote:

The problem now being that the reference is made to the file version stored locally on the PC's, not the masterdocument on Dropbox. This means that the link becomes user depenant (works only for the one who creates the link).


First, there is no master/slave relationship to the files you put in Dropbox. All changes are synced from all computers and no single copy is considered a master. Just putting that out there so there's no confusion.

 

Links to files will always need to be created using the file on your computer. There is no way to link to the file online (in the manner in which you're trying to do it). Also, as you've experienced, linking to other files within Office files (and most other programs as well) will always use the full path to the file. Relative paths are not possible within Office files. This means that the path will almost always be different on different computers since the user's home folder is usually part of that path. This is how Office and most other programs work and has nothing to do with Dropbox.

 

The only way to ensure that files referencing other Dropbox files will continue to work on other computers is to make sure that everyone's Dropbox folder is stored in the exact same location on each comptuer. Usually something like C:\Dropbox would work.

View solution in original post

5 Replies 5

Rich
Super User II
Go to solution

HRO wrote:

The problem now being that the reference is made to the file version stored locally on the PC's, not the masterdocument on Dropbox. This means that the link becomes user depenant (works only for the one who creates the link).


First, there is no master/slave relationship to the files you put in Dropbox. All changes are synced from all computers and no single copy is considered a master. Just putting that out there so there's no confusion.

 

Links to files will always need to be created using the file on your computer. There is no way to link to the file online (in the manner in which you're trying to do it). Also, as you've experienced, linking to other files within Office files (and most other programs as well) will always use the full path to the file. Relative paths are not possible within Office files. This means that the path will almost always be different on different computers since the user's home folder is usually part of that path. This is how Office and most other programs work and has nothing to do with Dropbox.

 

The only way to ensure that files referencing other Dropbox files will continue to work on other computers is to make sure that everyone's Dropbox folder is stored in the exact same location on each comptuer. Usually something like C:\Dropbox would work.

BBO_David
Explorer | Level 4
Go to solution

Hi Rich

 

Thanks for your info so far - I've been battling with this issue for a while now.  The linking between Excel spreadsheets is crucial for us.  I note that you say "The only way to ensure that files referencing other Dropbox files will continue to work on other computers is to make sure that everyone's Dropbox folder is stored in the exact same location on each computer. Usually something like C:\Dropbox would work."

Can I move a Dropbox folder so that it is directly under the C:\ drive and still have it sync with the website account?  Doesn't it need to be within the User folder to be recognised?  Thanks - David

Rich
Super User II
Go to solution

You can move to any location you want (external drives are NOT recommended). It will continue to sync to your account just fine. Just make sure you use the option in Preferences to do it.

 

Ed
Dropbox Staff
Go to solution
Would you mind taking a minute of your time to fill out a survey sharing your experience using our Dropbox Community? You can access the survey here: http://bit.ly/2lNKIxT

Thank you!



Ed G
Community Manager @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so please mark it for some Kudos 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_counterclockwise: Still stuck? Ask me a question! (
Questions asked in the community will likely receive an answer within 4 hours!)

BBO_David
Explorer | Level 4
Go to solution
Thanks Rich - much appreciated!
Need more support?
Who's talking

Top contributors to this post

  • User avatar
    BBO_David Explorer | Level 4
  • User avatar
    Ed Dropbox Staff
  • User avatar
    Rich Super User II
What do Dropbox user levels mean?