Excel and Dropbox S...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] Excel and Dropbox Shared Workbooks

10 Posts
5 Users
0 Reactions
99 Views
Posts: 13554
Free Member
Topic starter
 

Help me more enlightened members of STW. We use Dropbox in my team at work as a few of us tend to flit around different sites, myself included. As we all have to access the same workbooks throughout the day deleting conflicted copies has become a daily chore for yours truly.

Is there a way to share workbooks within Dropbox wherein multiple users can access, make changes, save them and just one copy with all changes is actually saved? Or am I condemned to play conflicted copy roulette where I have to choose the most likely up to date version.


 
Posted : 29/01/2020 8:36 pm
Posts: 13594
Free Member
 

Dropbox should do all that for you, but if two of you have the same file open, you still have a conflict which Dropbox can't resolve.

We use it for shared project spaces at work and sharing Excel workbooks etc without any trouble.

Possibly Google Docs is a better choice if you have people editing the same file simultaneously, but I've not tried that...


 
Posted : 29/01/2020 8:52 pm
Posts: 77687
Free Member
 

Use OneDrive instead.


 
Posted : 29/01/2020 8:58 pm
Posts: 13554
Free Member
Topic starter
 

Cheers footflaps. It’s editing at the same time that’s causing the issues. Couple of heavy traffic workbooks that see a lot of use. Looking for a solution whereby multiple users can edit the same doc simultaneously and all changes are saved. Thinking it might not be doable.


 
Posted : 29/01/2020 9:00 pm
Posts: 13594
Free Member
 

Use OneDrive instead.

Can't comment personally but people at work who have tried both OneDrive and Dropbox have slated OD as being slow and no where near as user friendly as DB. We get OD free with Office 365 but pay extra for Dropbox as it's so good.


 
Posted : 29/01/2020 9:06 pm
Posts: 77687
Free Member
 

... but it doesn't do what the OP wants and OneDrive with O365 does.

(As does Google Docs, as you suggested, and very well indeed.)


 
Posted : 29/01/2020 9:13 pm
Posts: 13554
Free Member
Topic starter
 

Same issue here. Pay for Dropbox and One Drive appears to cripple usability on a couple of PC’s. Will give it another test though. Pity Dropbox has this flaw

Cheers guys.


 
Posted : 29/01/2020 9:20 pm
Posts: 77687
Free Member
 

It's not so much a flaw as a lack of a feature, to be fair.


 
Posted : 29/01/2020 9:38 pm
Posts: 13554
Free Member
Topic starter
 

When I used my weak google-fu there were lots of complaints about it. You’d think they would update it really. Great tool apart from this.


 
Posted : 29/01/2020 10:36 pm
Posts: 433
Free Member
 

This is classic shadow-IT...

A shared Excel workbook in OneDrive may work (it allows concurrent editing) but what you really need is a proper solution - a spreadsheet isn't the answer here! Sounds like you need to invest in a CMS which uses a proper database back end.


 
Posted : 30/01/2020 9:08 am
Posts: 0
Free Member
 

Store the file in dropbox. Move the file to your PC when editing, put it back when finished.


 
Posted : 30/01/2020 11:23 am