Dropbox link keeps changing

[ajw1414]

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

[Jonathan H.1]

STILL nobody has bothered to reply.

[gkewing49]

did you ever get a reply?

[markbroemer]

nope

[gkewing49]

It appears I have found a fix.  I moved mine to local instead of online sync, went into any excel file and took off the autorecovery and autosave features.  This has made my links stay the same, even when running scripts and tasks.