I'm not dismissing onedrive here but I wanted to say monseur was cheating when he mentioned onedrive/sharepoint as real features of Excel application – they are not directly related to the essence of spreadsheet editing and can be substituted with any solution which does the job, even Dropbox itself.
>There's no serious alternative to Excel for those who rely on its advanced features.
this is just silly, it really means "There's no serious alternative to Excel for those who rely on exclusive Visual Basic macros"
> I'm not dismissing onedrive here but I wanted to say monseur was cheating when he mentioned onedrive/sharepoint as real features of Excel application – they are not directly related to the essence of spreadsheet editing and can be substituted with any solution which does the job, even Dropbox itself.
Not true. Sharepoint and OneDrive are key enablers for real time collaboration. It lets multiple people work on the same file at the same time using native desktop applications. Dropbox has tried to bolt stuff like that on, but it is janky as heck. OpenOffice, etc can't integrate with Excel for real time collaboration (honestly, I'm not sure they support any level of real time collab with anything). Google Sheets won't integrate with Excel for real time. Google is great for collaboration, but sticking everything in Google's cloud system isn't dramatically better than being stuck on Microsoft's stuff. Also Google Sheets just doesn't work as well as Excel.
SharePoint/OneDrive Lists can be directly edited in Excel. The Power platform can directly access/manipulate/transform Excel files in the cloud or on-prem via the Power BI Gateway.
You don't seem to have much of a familiarity with this ecosystem. If you're curious, I'd suggest hunting down these things on learn.microsoft.com, but to dismiss them is only showing your lack of understanding.