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

Forum Discussion

donf13's avatar
donf13
New member | Level 2
2 years ago

Looking up a value in an Excel file in Dropbox.

Our company has one excel file in dropbox and another file on my computer looks up a value from a column in the dropbox file.  Others need to use the file on my computer, so is there a way to change ...
Microsoft
Microsoft Office
Rich's avatar
Rich
Icon for Super User II rankSuper User II
2 years ago
donf13 wrote:

Others need to use the file on my computer, so is there a way to change the link so it will work for everyone?

As you've discovered, Excel uses full paths when linking or referencing another file, and will not work with a relative path or an environment variable (such as %USERPROFILE%). The only solution would be to relocate the Dropbox folder for each user so that it's in a common location, such as C:\Dropbox, so everyone is using the same full path.

 

You might be able to set a custom variable using VBA, and then use that variable in the lookup path, but I've never tried that. Try Google for more information on that.

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!