Excel – In excel shared workbook can you insert data and not replace on conflict

microsoft excelmicrosoft-excel-2007

I have 2 users that asked for a shared excel workbook a while back.

Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just inserted the rows like a database, one after the other.

I would like to know if there is a way to have multiple users insert data in excel by not overwriting data but just appending the rows in an excel file?

Any help would be appreciated.


Shared Workbook

Best Answer

If sharing is turned on, it should be merging the data. Unfortunately, Excel's shared workbook feature is not a reliable tool. If the data is critical, you may want to consider not sharing and the users can only add their data one at a time. OR consider using a program, like Access, which is made for data sharing.