Links to Excel documents on SharePoint are downloading instead of opening in app or browser
I was posting about this on a different thread but was asked to start a new feed (https://techcommunity.microsoft.com/t5/office-365/links-to-sharepoint-document-in-excel-opens-in-browser/td-p/183028#.XtUCofR6gAE.link)
If I provide a link to an Excel file stored on SharePoint via e-mail, Teams, Skype, etc., the file downloads and does not open in the native app (like it used to). I am using the direct link, not the SharePoint provided link. I know I can add ?web=1 to the link to force it to open in the browser and that is what I am doing (when I remember) for now.
The whole point in putting an Excel file on SharePoint is to allow us to collaborate on the same file and not have to collate information from different people who have downloaded and edited the file and sent it to me (!) (Note: the fact that I am getting files sent to me like this is evidence this is happening to others, as well, and not isolated to my computer or my settings.)
I have not checked this with Word or PowerPoint.
I do not understand why this behavior is happening. It cannot be browser dependent as it is downloading. It may be SharePoint library settings but I can only find settings to force it to open in app or browser NOT download?
Any help to prevent downloading as default is appreciated.