Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

Oliver243234's avatar
Oliver243234
Explorer | Level 3
3 years ago

Linking Excel files in Dropbox across multiple users

We have several Excel files with formulas that link to other Excel files all saved in a shared folder.  With our local server the links would work for every user the same.  Now with using Dropbox, th...
Microsoft
Microsoft Office
Third Party Integrations
Rich's avatar
Rich
Icon for Super User II rankSuper User II
3 years ago
Oliver243234 wrote:

How do we make it so all users in the shared file can open the Excel file and have the links update without having to change the file path for each user?

This happens because Excel and most other applications use the full path to the linked file, not a relative path, and since the Dropbox folder will be in a different location for every user, the paths will be different for every user.

 

The only way to make this work is if everyone stores their Dropbox folder in the exact same location, such as C:\Dropbox and the shared folder is in the exact same location with the same name for everyone.

About Integrations

Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

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, Facebook or Instagram.

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!