How to find file location that my coworker can access

Sunshine_9787

How do I find a file location that allows my coworker using his computer to access the file? For example, the file location from my end is C:\Users\... My coworker cannot access the file because the location is from my comptuer. Is there a path where both of us can access the file?

Walter

In that case, I'd suggest using wildcards like %HOMEPATH% @Sunshine_9787!

 

Note that when your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example /Your_Computer/Your_User/File, and that location is no longer accessible from a different computer.

 

To learn more about relative and external paths in Excel please consult the following Microsoft support page:

 

• https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel

 

While we are unable to support you in configuring Microsoft Excel to work the way you would like, we usually suggest using wildcards in your formulas. Wildcards, such as "%HOMEPATH%”, if other users have the Dropbox folder located in the default location (the C drive for example), would let you point to a location without having to worry about different usernames in the path.

 

I hope this helps!