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.

Settings:

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.