Google is completely out of the question. As I said, we cannot switch away from Excel, whether I like it or not. Google Sheets is not a viable option: Everyone in the company knows Excel.
Network shares aren't bad per se, but they encourage people to place multiple files with the same name and then a V4, V5, V6 etc suffix. People have to download or check out the Excel files if they want to work with them, delete their local copies when they are done, and make sure they always check out the most recent version. If multiple people have to edit an Excel file, they have to synchronize so they don't override each other's files. So yeah, network shares aren't bad per se, but they aren't ideal either. SharePoint has a clear advantage here.
I'm not usually someone who advocates for Microsoft, on the contrary actually, but in this case I don't see a really good alternative.
If you have a better workflow, please explain it to me.
Network shares aren't bad per se, but they encourage people to place multiple files with the same name and then a V4, V5, V6 etc suffix. People have to download or check out the Excel files if they want to work with them, delete their local copies when they are done, and make sure they always check out the most recent version. If multiple people have to edit an Excel file, they have to synchronize so they don't override each other's files. So yeah, network shares aren't bad per se, but they aren't ideal either. SharePoint has a clear advantage here.
I'm not usually someone who advocates for Microsoft, on the contrary actually, but in this case I don't see a really good alternative.
If you have a better workflow, please explain it to me.