Just because they are moving the files to SharePoint, it doesn't mean you have to open them with the On-Line version of Excel, unless they are removing your local Office Subscriptions as well?
There are quite a lot of restrictions with the performance and features of the Online Web version, and if you are even a slight "Power User" you won't put up with it for long.