One person to be allowed to use excel at time

tspiewankiewicz

Since the outbreak we have been struggling with some file sharing. The most common files, such as excel with basic data - that is being used constantly have been corrupted due to the people not being able to recognize the fact it has been open elsewhere. 
Is there a way to block an excel sheet to one location at times ? 

Daphne

Hi there @tspiewankiewicz, I hope you're well today!

 

It sounds like you might be referring to "conflicted copies" being creating, is that right? If so, there are a few suggestions I can make to keep collaboration easy to do.

 

If you're part of a Business team, then you can use the file locking feature to prevent others from making edits to the file, but allowing them to still view it while locked. You can out more about this feature here.

 

Another option is to edit the file online. Opening the file using the Microsoft Excel Online option will allow you to collaborate in real time on the same file.

 

Otherwise, if you're editing from the desktop and syncing your files through the desktop app, you can use the Dropbox Badge to see who is viewing or editing the file.

 

I hope this helps, let me know if you have any other questions!