We have an Excel file that is too large to open online that is shared among our members. When we open it, we get the error that it is too large to open then there is an option to open in Excel. We can right on the file to choose open in Excel.
Is there a way to automatically open the file in Excel when Microsoft Teams starts?
As second option is there a way to make it default opening in Excel or to automatically open in Excel if it can't open online?
From what I can tell, technically yes there is, but it still requires a couple of clicks from the user so you don't really gain any efficiency :(
You can open the SharePoint site that houses the files. Go to the 'gear' icon then Site Information - then Site Settings. Click Site Collection Features - locate 'Open in Client Application' and click Activate. This will force all files stored on that SharePoint site to open in their client application instead of the Online version.
Here's the kicker, it still only works if they are opening the file via SharePoint. From the Team, Files tab, click Open in SharePoint. Then if they click directly on the file, it will open in Excel.
It's probably just as easy to educate the user to right click then open the file in Excel.