0

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

5
  • What do you mean "The file just inserted the rows like a database"? Are they both working in the file at the same time? Are they both using the same version of Excel (you tagged two versions)?
    – CharlieRB
    Jan 22, 2015 at 12:46
  • CharlieRB: thx for commenting. Yes they are using the same file at the same time. My apologies they both use 2007.
    – Nightwolf
    Jan 23, 2015 at 6:16
  • Consider a row of cells as a entry, and they both want to enter multiple entries, and don't care too much about the exact position their entries go. So they both type in cell A15 but instead of giving conflict on saving, they want one person's entry to go to A16.
    – Nightwolf
    Jan 23, 2015 at 6:19
  • What are the settings under the 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 the Advanced tab of the Share workbook window?
    – CharlieRB
    Jan 23, 2015 at 12:31
  • As you can see, excel assumes conflict resolution should be rewriting a cell. I would like to know if there is a way to shift rows down and insert conflicted data so both info stays.
    – Nightwolf
    Jan 23, 2015 at 13:22

1 Answer 1

1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .