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:
Review Tab > Changes > Share Workbook
? If "Allow changes by more than one user at the same time. This also allows workbook merging" is not checked, then the workbook is not properly shared. Also what are the settings on theAdvanced
tab of theShare workbook
window?