I have a workbook I would like to share with colleagues which records client
details. However if, for example, user 1 enters a new client on row 1 and
saves, then user 2 (who has the un-updated version open) then adds a new
client to row 1 and saves the Resolve Conflict window opens up asking which
change to keep and which to discard.
Obviously I would like to keep BOTH new clients data but can't see how this
can be achieved.
Am I being particularly dense or is there a workaround?