Indesign use to be smart enough to know that links are from dropbox and looks for the my dropbox folder and not the link path that goes all the way to the drive name.
But lately every time I open a file from a team member, I have to relink ever file manually.
Jason Bartley commented
Also the same problem with Google shared drives.
I also have this problem.