Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Solved
Files in a shared folder went back to their previous versions, after I was removed from it
One of my clients shared her dropbox link with me. I started working on the shared files using my local dropbox folder on my desktop. while i had access she could check that work is getting updated on her local dropbox folder on desktop as well. But once she removed access all the files on her local dropbox folder went back to their previous versions and all the work was undone.
I am not able to solve this issue
Kindly help
Hi there and happy Monday!
I don't think transfer would also be a viable solution to what you're trying to do.
Perhaps you might want to consider shared folders with wildcards in your Excel formulas.
Wildcards, e.g. "%HOMEPATH%”, would let you point to a location without having to worry about different usernames in the path, if the other user has the Dropbox folder located in the default location.
You can see more info here.
13 Replies
- Rich
Super User II
surajkjha wrote:
But there is one concern. If i share the link to folder then isn't it possible that once she downloads the files #ref error will be there and again the work will be undone.Yes, that's very likely to happen again but it's because of how Excel works with linked files, and not an issue with Dropbox.
When you link to another file in an Excel sheet, the full path to the linked file is used. If your Dropbox folder is in its default location, then that full path will likely include your computer username in the folder structure, such as C:\Users\surajkjha\Dropbox\somefolder\somefile.xls or similar. You then share this folder with someone and it syncs to their own Dropbox which likely won't be in the same location as yours. They open the file and Excel is still going to look in that same path for the linked file and when the file can't be found, you get the #ref errors.
The only way to use shared Office files that link to other files within Dropbox is to have the Dropbox folder on both computers be in the exact same location, such as C:\Dropbox. That way the full path to a linked file is the same for both users. Though keep in mind that this still does prevent it entirely. Shared folders can be moved and renamed by any member without affecting the folder for others, and doing so would break any file links.
- Yes I am also afraid of similar situation and same path and same location is not a feasible option.
If we use file transfer of Dropbox, then is it possible? - Hannah
Dropbox Community Moderator
Hi there and happy Monday!
I don't think transfer would also be a viable solution to what you're trying to do.
Perhaps you might want to consider shared folders with wildcards in your Excel formulas.
Wildcards, e.g. "%HOMEPATH%”, would let you point to a location without having to worry about different usernames in the path, if the other user has the Dropbox folder located in the default location.
You can see more info here.
