My team and I recently migrated to MS Teams and the whole host of MS Office products for our daily work. We work online and collaborate on the same documents, a lot. We were earlier using Google Sheets and were perfectly happy with it, but with this migration, we had to move our spreadsheets also to Excel. While I was initially happy about there being a co-authoring option, it has proven quite disappointing. I am unable to open a workbook and edit it if it is open by someone else, and it automatically opens to read-only ALL the time, and it's really really frustrating. Why create an online collaborative option if people can't edit it at the same time?
Has anyone else faced the same issue? What can be done about this? Or am I missing something? Please help me out here because I'm just a few weeks old to all this and could use all the help.