a shared drive is much better than sharepoint. I don't see how sharepoint can make it easier.
the best alternative is using google workspace instead. it doesn't make you sign in four times a minute.
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.
What’s the big difference between Excel and Sheets?
So if you can’t tell the difference between those products how can you tell the difference between Excel and Sheet?
They KNOW excel, they know where which buttons are, and the business logic and price calc are done in excel. These people aren't mentally challenged as you seem to think, they will know if their excel suddenly looks differently, offered by Google instead of Microsoft and in a browser instead of a native windows app.
So if you have nothing to contribute except power user arrogance, I will no longer interact with you.
Lol. You answer rude and get a rude response and then give up.
> They KNOW excel, they know where which buttons are
That’s not knowing excel though.
You’re not making the claim that people writing complex formulas with named ranges have an equation that doesn’t work in Sheet.
Sure, not specializing in computers doesn’t make you mentally challenged but it doesn’t make you proficient in it. If the reason somebody can’t use something is cause it “looks different” how have they survived the last 2 decades of Microsoft changes?
But the excel-boundedness is exactly my point. Several sheets are so large they have been split into three files, referencing each other or external sources via power query. I'm not even saying it's good like it is, but it's just the status quo. I don't see any viable way to turn away from Excel in the short term, which is why I seek solutions.
And knowing where which function or button is in Excel IS knowing Excel, and programming formulas, VB macros and power queries is knowing Excel too. It has been a cornerstone in this company for the past 20 years. These people aren't IT people, Their core skills and how they bring value to the company lie somewhere else, and that's perfectly fine too. but I cannot expect them to just change the software they're been relying on for years just because I say so.
Last time i looked, ability to handle more than a couple of thousand cells.