3
What is the best way to allow multiple users to edit the same excel file and later merge the files together with conflict resolution?
Excel with Version Control - Best way to merge excel files?
Answers
1
Under the Review tab, in the Changes group, select the "Share Workbook" option, check the "Allow changes by more than one user at the same time" box. Now you can save the file on your network, and have multiple users workin in the file at the same time.
user2597747
Posted 2011-11-04T23:27:43.090
Reputation: 261
This probably is a good solution, but if you use excel 2016 (and prosumably older versions as well) it significantly cripples funtionality. So users will still have to make sure to unshare, merge cells and share again (loosing all concurrent work at that time) when merging cell, working with tables etc. – Hennes – 2018-06-23T12:48:04.163
1http://office.microsoft.com/en-us/excel-help/merge-copies-of-a-shared-workbook-HP010177169.aspx or http://www.gcflearnfree.org/excel2010/extra/63 – None – 2011-11-05T00:02:00.357
Will this work if people edit the same cell? – None – 2011-11-07T18:24:26.780
1No idea - never done it myself. Simple enough to try it out though. – None – 2011-11-07T20:53:07.890