My assistant and I use the exact same excel sheet. It is a list of people and companies we do business with some basic information about them. It's all text, no formulas or links. We each make small changes during the course of a day. Often we BOTH have the sheet open at the same time. The sheet resides on our cloud service and when we both make changes and each save the file gets marked "Conflicted Copy."

If we hade 2 exact duplicates of the same sheet and they somehow synced, our problem would be solved. Is there a way to make them automatically sync? Syncing after saving is fine, it doesn't have to be real time.

Thank you in advance.