Power Query Link for Dropbox

[ebjacob1978]

Hello All
I recently made a bunch of excel sheets connected with each other through power query.
But since I wanted that sheets to be accessed online, I put all those files in DROPBOX folder.
It works fine on my laptop, but when I check from other devices, the link is broken and refresh doesn't work.
I am not good with VB or any coding language. I am good with Excel and but beginner in Power Query.
Please suggest a best way to fix this.
Regards
JACOB Ebanezer

 

[GWteB]

It works fine on my laptop, but when I check from other devices, the link is broken and refresh doesn't work.

This is because links between workbooks are not relative but absolute. That's by Microsoft's design.
It means the full file path is used for these types of links. Typically these paths look like this:

C:\Users\ebjacob1978\Dropbox\WorkBook Example.xlsx

Although you can also access these files directly in the cloud, a path to such a file looks much different, something like this:

https://www.dropbox.com/scx/fw/lvjkrvuf4kr3koxrqfjq13/WorkBook%20Example.xlsx?context=browse&role=personal

and in dropbox's local network a path could look like this:

\\dropbox.svr\clientse\ebh-ebk\ebjacob1978\Workbook Example.xlsx

I don't think the following will help for Android mobile devices, but for Windows machines it may be advisable to move the local dropbox folder in such a way that it has the exact same path on every machine, so user profile independent, for example:

C:\Shared\DropBox

So don't work directly in the cloud but with your local files within dropbox's folder. After synchronization you also have the most current versions on other devices.

Hope this helps.

 

[ebjacob1978]

I changed the dropbox location to D drive
and changed in all other computers...
It worked... Thanks!!

But, how about if these excel files are located in various locations, instead of dropbox?

I understand that, I should make a set-up sheet with a table showing the path and folder name in each excel files, which looks like below.
Parameter is just for my understanding, Value is the location and exact name of excel files.

From here onwards, I don't know how to link them with power query, so that power query reads this link to connect.
Please let me know if you can help me on this...

Thanks once again
JACOB

 

[GWteB]

As you will have understood by now, your issue was not PQ specific. Although I am not very familiar with PQ I was extremely sure of the cause of your problem, that's why I replied.
Regarding your additional query hopefully another forum member is able to step in. Meanwhile this video may be of some interest ...

 

[GWteB]

In addition to my previous post, I would like to point out a DropBox issue from another forum member, which he found a solution for elsewhere on the net.
Not sure if this information is of any use to you. Just to let you know.

Saving file using VBA on Dropbox for business

Hello everyone. I'm really hoping someone can help as this one has really stumped me and I've searched all afternoon for the answer but can't find anything. My issue is I've just moved to a new company which uses Dropbox (first time for me) and so I'm struggling to work out how to do things...

www.mrexcel.com