Morning,
I have a excel file on dropbox where I setup a macro to have a powerquery run overnight to pull data from our databases and then save. What we call our master data excel file.
Afterwards we have individual excel files linked to this master excel file to update account information. Some 250 individual files.
This approach was working file for our team over the past year, but just yesterday we noticed that the dropbox link on the master file has changed. Causing all 250 files needing to be relink.
I noticed this morning that the link has changed again.
There has been no changes to the file other than the data uploads over night.
Can anyone advise what the issue is? Thank you