A friend asked me the other night if I knew of a way that he and his business partner could share a spreadsheet in a way that they wouldn't have to worry about who has the file open at any given time.
He wanted to know if there was a way to share an Excel spreadsheet so both could work at the same time without disrupting each other's work, and without having to email it to each other or dealing with accessing it from a shared hard drive.
He didn't want to have to email it to each other whenever they made a change. That is just a nightmare and so 2002.
I was a bit taken aback because I thought everybody knew about the solution for this by now. But apparently I was wrong, I told him I had the solution for this, but I still wanted to hear his requirements. I think this answer might help you as well.
I listened to all the requirements he told me. I wanted to make sure that I wasn't missing anything and he didn't need anything too robust like a proper MySQL or NoSQL database. He didn't; he's in real estate and just needed to track stats and properties related to the business.
He wanted something just like his Excel spreadsheet, but better.
Continue reading here: https://notagrouch.com/want-excel-spreadsheets-need-something-better/