Link to an Excel file on a dropbox folder?

[jflechet]

Hello,

I'm new to this forum and this is my first post. I've been looking all over for a solution but can't find it.

I have several spreadsheets: MASTER.XLS and SLAVE1.XLS, .... SLAVE6.XLS

All files reside on a shared DROPBOX folder for other users to use. One user updates the MASTER file on a regular basis (pricing information) and I'd like those to be reflected in the SLAVES files.

Say I want to grab the content of A2 from the master file. If i use the local version of the file, there is no issue for me but it won't work for other users as the file is not stored in the same place on their dropbox folders

=+'C:\Users\jf\Dropbox\[Master.xlsx]Sheet1'!$A$2

I tried to get the address from the file directly from Dropbox

The link I obtain from dropbox is https://www.dropbox.com/s/704gvz08aq...ster.xlsx?dl=0

I tried the following formula:

=+'https://www.dropbox.com/s/704gvz08aqvlt65/[Master.xlsx]Sheet1'!A2

but I get an error message: "Excel cannot update one or more links in this workbook. To update the links, open all the linked source files ... "


Does anybody know how to get the above formula to work and to refer to the file in the cloud and not to the image stored locally on my computer?

thank you in advance for your help,

Jean-Francois

[pjwhitfield]

I dont know if this is the best way to do it but I found a link to using VBA to find the location of the dropbox folder on a users PC. You could therefore use this function to set the link for each user so they are using their own local copy (which then automatically updates the cloud version).

http://dailydoseofexcel.com/archives...folder-in-vba/