Our team uses Dropbox for Mac to collaborate on Microsoft Word documents. Many of our Word documents include embedded graphs from Excel. The pathways for these links are absolute, e.g.
/Users/Citizen Math/Citizen Math Dropbox/Lessons/LessonName/Spreadsheet.xlsx
Normally, Dropbox automatically places the root directory in the user's main directory, in my case "karimani." However, this would break the connection between Excel and Word for other members of my team, since their directories are named something other than "karimani." As a workaround, everyone on our team (1) created a new directory called "Citizen Math" in the Users directory, then (2) moved our Dropbox directory there. That way, whenever someone opens a Word file with an embedded Excel sketch, the graph's pathway is the same for everyone.
However, Dropbox recently announced a new change which breaks this. Instead of allowing users to designate where to save the Dropbox directory, it will move everything to a new directory within the user's home directory. In my case, this would be Users/karimani/Library/CloudStorage. Since this pathway includes "karimani," the links can no longer be the same for everyone on the team.
The way I understand it, the problem does not exist with Dropbox. Rather, the problem is due to the fact that Microsoft uses embedded links that are absolute (i.e. starting at the home directory and going forward) and not relative (i.e. starting at the Word document and going backwards).
Is there any way to fix this? Specifically, is there a way for teams to collaborate on Word documents that include embedded Excel graphs without having to update/change the graph's link pathway each time?