|
I have a spreadsheet that I wish to share with multiple users. When two users 'save' at the same time it only gives the option to save one of them. I was hoping Excel would just save one of the conflicting changes to the next row. Is there a way to do this? |
||||
|
|
Not too sure whether Excel has a hassle free solution for this. But I feel you can figure out some ways by referring to above mentioned answers. Certainly even Google docs has certain drawbacks as it does allow me to hide a certain column from some one who has access to edit. Well, you must be aware of CollateBox, it not only gives you the provision of sharing spreadsheets but also sharing parts of your spreadsheets. You cant give it a try, its in its beta so try working!!! http://www.collatebox.com is the link. Would appreciate your reply.. |
|||
|
|
|
You can switch on the "Share Workbook" feature from the "Review" menu. This allows multiple simultaneous users - however it still doesn't do exactly what you want. In this mode, you cannot change the layout of spreadsheet (add/remove rows, etc.). If two people edit the same cell, you get a conflict dialogue not a new row. I do not believe that Excel is the correct tool for this case. If you really need multi-user live editing, I'd try a different tool, perhaps Google Docs may be closer to your needs, the multi-user editing in that is pretty good though it still wont create a new row on a conflict, I don't know anything that will do that. I believe that you would need to create a bespoke tool for that. Perhaps MS Access or a web-based app. |
|||
|
|
|
You can use Microsoft Live and SkyDrive to share office documents with multiple users along with tracking history of changes. Generally most programs don't try and merge changes or handle conflicts automatically. Usually it is the last one in wins. |
|||
|
|
