![]() ![]() ![]() I trained them to click on "Open in Excel" from the drop down or open in Excel from the browser Excel, but I kept getting calls that the macro wouldn't work (due to the file being open in the browser). In particular, I have a dashboard page where staff expect to click on the document to open it in the app. I too tried making the default behavior to open Excel in the app not the browser and the steps did not always work for me. The URI schemes article describes how to setup links for Excel and other MS Office programs, and the options that are available to open the documents such as in view only or edit for encouraging me to look at this again. You would then need to right click on the cell and click Link and set it to be a hyper link with the address using the same exact text with the entire contents of the link included in the address. To create a hyperlink that links to an Excel document in SharePoint online, and to open that document in Excel with editing enabled without being prompted, this would be the format: You will need to use the customized link as mentioned already with the addition of the URI scheme to open the Excel program without prompting when using a link from within an office application, or if you want to create a regular link you can place on a users desktop or in my documents that links to the SharePoint file. ![]() This website contains information on URI schemes with MS Office applications. If you want to avoid the user being prompted to open the Excel program when using the customized link, you can use Excel URI schemes to modify the custom link. It may still prompt to click ok in the future when clicking a link that defaults to open in the program.Īlso, you will need to make sure that in Library Settings for the site, and in Advanced Settings, that you have set the default open behavior for browser-enabled documents to open in the client application. You will need to make sure their default web browser is logged into Office 365, and that the prompt to allow the document to open in the program is accepted and you can save the choice. This document will now open in Excel the program rather the web browser. However, if you browse to the document library, and then copy and customize the address and add the filename, you could make the link look like this: You will need to customize the link in order for it to open in the local program.įor instance, this link will open a document called Test.xlsx in a web browser: after many hours and then Microsoft support. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |