How can we edit an Excel file simultaneously, without overwriting it?

Question

We have a current orders spreadsheet that three of us access and make changes to. We make a separate tab for each day's orders. Routinely when I open the file in Excel, I am presented with other versions to save or discard - even when I'm the only one who has been working in the file, and I save after every update session.  We've 'lost' a number of orders because of file overwriting.

What's the best practice for maintaining an accurate orders file that can be updated or notated by three people, sometimes simultaneously? Do I have to move this to (ugh) Google Sheets?

TIA!

Mark · Answer

What's the best practice for maintaining an accurate orders file that can be updated or notated by three people, sometimes simultaneously?

Make sure you are all opening and editing via the website. If you are opening and editing it on a computer it doesnt have simultaneous editing capabilities.