You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.

Forum Discussion

ajw1414's avatar
ajw1414
Helpful | Level 6
6 years ago

Dropbox link keeps changing

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

Share
Shared Links
Third Party Integrations
  • ajw1414's avatar
    ajw1414
    6 years ago

    Thank you all for the response.  

    I ended up submitting a ticket in through Dropbox.  This appears to be related to a update they performed.  They rolled back for my individual file and the link appears to be staying the same now. 

    We ended up moving our master data file to a local drive.  This does mean we have to relink 250 files, but at least we have control of such issues in the future, but I wanted to post here in case others have the same issue going forward.  Good luck.

     

    I just received an update from our engineering team with news on a temporary fix. 

    It looks like we were able to isolate this issue to a recent update of ours. While we're working to get this fixed, we've rolled back the update for your account and I've verified that the machine you contacted us about initially, "CHS4156695", has reverted that update. 

    My team will continue to work on getting this fixed - but we didn't want that to be at the cost of your productivity. 

    I'm going to leave this ticket on-hold for the time being as I monitor for updates, but you should be good to go. 

    • ajw1414's avatar
      ajw1414
      Helpful | Level 6
      6 years ago

      Hi Walter, thanks for the update, but not quite the same issue.  It appears that after a file is saved that the dropbox link now changes.  I'm unsure why. 

       

      Old Link

      https://www.dropbox.com/s/6pcuy45qfpgal5d/FILE Name

       

      After updating/performing a data pull, then saving the file.  We now have new links which detroys out power query links between the excel files.  The link change has never occured before.  Not sure why it's an issue now.

      https://www.dropbox.com/s/ljdikwwbqcqgoy8/File Name

      https://www.dropbox.com/s/frxvvct2nblz3o7/File Name

      • Walter's avatar
        Walter
        Icon for Dropbox Staff rankDropbox Staff
        6 years ago

        Thanks for following up and providing the extra details here ajw1414.

        I'm still not sure how shared links to files of yours can be altered after running a macro in Excel; I'd love to look into it though.

        Therefore, would it be OK if I reached out via the email address that's connected to your Community's profile to dig a tad deeper into this matter? 

About 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.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!