![excel files open blank from onedrive excel files open blank from onedrive](https://cdn.windowsreport.com/wp-content/uploads/2017/09/add-ins.jpg)
Reference this post as well for a full list of limitations of browser vs.B-E see the file in the folder via a web browser BUT when they try to open it, it opens in Excel online. User A stores an XLSX in Onedrive and wants users B-E to have read/write to it so A sets up a shared folder giving R/W access to anyone with the link and puts the XLSX in there. Users B thru E have traditionally licensed Office 2016 on their desktops. If users open the files in the native (desktop) applications, when you click the Save button from Word/Excel/PowerPoint – the files go back to where they came from (SharePoint document library or OneDrive) User A has Office 365 with OneDrive for business.Unlike the browser experience, where AutoSave is on by default and can’t be disabled, AutoSave can be controlled from Office settings ( File > Options).These files will open in the browsers no matter what. The same applies to the files created from a Template from the New drop-down.When you create new documents using the New drop-down button – they will still open in the browser despite the changes you make above.For this, the following steps needs to be followed: Open any one of the excel files in MS-Excel installed locally. the actual path of the folder where the excel files are located. The next step is to find the web URL to the folder, i.e. Other file types (i.e., PDF) are not supported In this example, we have three excel files with the same structure in the ‘Test Files’ folder of Onedrive. The above techniques only work for Office file types (Word, Excel, PowerPoint, OneNote).When you share or copy links to files – they will always open in the browser The above techniques only work for docs open from the library, not sharing links.And just like with the SharePoint example above, click Activate next to Open Documents in Client Applications by Default.From your OneDrive page, click Gear Icon > OneDrive settings.If you want to default Office files to open in the native app in your own OneDrive, here are the instructions. Click Activate next to Open Documents in Client Applications by Default.If you want to default Office files to open in the native app for the whole SharePoint site (all document libraries located on that site) – please follow the below instructions instead. Under Opening Documents in the Browser section, change the radio button to Open in the client application.Navigate to the document library, click Gear Icon > Library settings.If you want to default Office files to open in the native app for a specific document library – please follow the instructions below. Instructions are a bit different for SharePoint and OneDrive.
![excel files open blank from onedrive excel files open blank from onedrive](https://thesweetsetup.com/wp-content/uploads/2019/08/Excel-Templates-with-Frame.png)
If you would like to automatically have the Office files open in the native (desktop) applications, then you would need to change some settings behind the scenes.
#Excel files open blank from onedrive how to
Right-click above the file > Open > Open in app How to default Office files to open in the native app Any user at any time can manually bypass the browser experience.