User Profile
80Mark80
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Links to Sharepoint Document in Excel Opens in Browser
job1986I think that if there is a macro involved that using Excel in a browser is a not a good long term solution. If you are using Office 365, it is possible to have multiple people editing the file at once, what Microsoft calls co-authoringand here, using OneDrive. I've trained users to select "Open in the Desktop App" from the menu, sometimes available in SharePoint or to open the desktop app from the browser, but I've had more luck recently having users sync the folder that the Excel file is in with OneDrive. Then from Windows file explorer the user opens the file. I haven't tried co-authoring this way, but I think that it should work if the User's OneDrive's settings for Office file collaboration has the "Use Office applications to sync Office files that I open" checked (Microsoft help). It may also require auto-save to the cloud to be enabled.6.5KViews0likes6CommentsRe: Links to Excel documents on SharePoint are downloading instead of opening in app or browser
ShelliG_NIt probably won't have an effect on your issue, but that is the browser that I have been testing with--if you were using the older version of Edge, it might have different functionality, like downloading instead of opening a file. Good luck.20KViews1like1CommentRe: Links to Excel documents on SharePoint are downloading instead of opening in app or browser
ShelliG_NHi, Thanks for creating the new thread. I have tried to duplicate your experience of having the file download instead of opening in the desktop app, Excel in this case, but haven't been able to duplicate it. I tried a link from an email message, which looked like this: https://mySharePointSiteName/sites/Ops/Shared Documents/IT/SampleFileName.xlsx and it opened in the Excel desktop app. I'm sorry not to have any more suggestions. Perhaps if you are using the older version of Edge (pre-version 80) you might try the latest version? Hard to do if you don't control your IT environment.20KViews0likes3CommentsRe: Links to Sharepoint Document in Excel Opens in Browser
ShelliG_NThanks for the additional information. Teams appears to be opening Office files, like Excel, in a browser-like view which for Excel gives the confusing options to open in the desktop app or just to edit or view in Teams. This is confusing for most people. If you want to avoid this, then try this approach, which is related to the current thread of opening Excel files from SharePoint. From Teams, select the option to "Open in SharePoint." This should open a view of the SharePoint document library in the default browser--I've tested this in Edge for Excel and PowerPoint files. The first time you access this document library, see if you have the privileges to update the Document "Library Settings" (from the setting "gear" in the upper left, near your Office 365 account picture/initials), advanced settings, to select the option "Open in the client application" for "Opening Documents in the Browser." If you were able to do that, then the next step hopefully works for you. Now click on the file you want to open in the desktop application from the SharePoint Document Library (not from Teams), and it should open in the desktop application. This works for me using Office 365 E3 / Excel (and PowerPoint) / SharePoint Online (modern experience) / Edge (v.83.0.478.37) on a Windows 10 Pro (v.1909) machine. But as you can tell from this thread, your mileage may vary--even if you have exactly the same setup, SharePoint can frustrate. And I'm not sure that it less confusing to users to have to go to the SharePoint side of Teams before opening a file, but at least they won't have both the Teams and the Desktop app showing them the same file (really confusing).142KViews0likes1CommentRe: Links to Sharepoint Document in Excel Opens in Browser
ShelliG_NThanks for the additional information about your system configuration. We haven't been using Teams to access files like that. I just uploaded a PowerPoint document to try it out. Teams seems to have a version of PowerPoint built in, so the document opened inside of Teams. Not exactly the desktop application but maybe good enough. To get the PowerPoint file to open in the desktop application I had to click on the "Open in SharePoint" menu option on the the top menu. I then updated the Document Library settings (hopefully you have privileges to do this) via the setting menu (gear in upper left corner). Select "Advanced Settings" and then select "Open in the client application" for the "Opening Documents in the Browser" setting. Then, if you click on "Open in SharePoint" from the Teams menu and click on the file in the SharePoint folder that opens in your browser, the document will, hopefully, open in the desktop application. This worked for me when I used Edge as my default browser. Once you have updated the library setting, it should apply for all users and you shouldn't have to change it again. But with all things SharePoint humility applies, so no guarantees. Still probably not what you wanted to hear. But I hope it helps.141KViews0likes0CommentsRe: Links to Sharepoint Document in Excel Opens in Browser
ShelliG_NWe have felt your pain. You may not have the privileges to change your library settings, but I would first try to follow the advice of Anonymous (04-16-201802:09 PM) tochange the libraries' Advanced Settings/Opening Documents in the Browser to "Open in the client application." If you want this behavior to apply to the site in general, and have the administrative privileges to update the site settings, then turn the Open docs in client app by default option as well (Site Settings > Site Collection Administration > Site Collection Features > Open Documents in Client Applications by Default.). Lately, I have had success using the Edge browser with these settings. Firefox has an internal setting controlling which apps open which documents, that would sometimes get reset (maybe on an update?), which added to the confusion of users that expected the app to open but the file would just get downloaded instead of downloaded and opened. We don't support Chrome (historical reasons) so I haven't tried it lately. If none of this works, we have at times, added specific links to menus or to HTML sections on pages. I think following the advice ofdomemsgroupfor how to refer to the files is the best approach--use a link that directly refers to the file, library URL + file name, and not the link that SharePoint gives you.This approach has allowed us to evade changes in behavior due to SharePoint updates or browser variation. Not very satisfying, but a few key documents resulted in more than their fair share of help desk calls. Good luck!142KViews0likes6CommentsRe: Links to Sharepoint Document in Excel Opens in Browser
domemsgroupThanks for encouraging me to look at this again. 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. In particular, I have a dashboard page where staff expect to click on the document to open it in the app. 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). I don't want to go in and create the links as you described, so for these sorts of pages I add jQuery and a reference to a script file that removes the SharePoint behavior of opening the file in the browser by removing the onclick attribute of the hyperlink tag. <script type="text/javascript"> // tested with jQuery 1.11.3 $(document).ready(function() { $("a[onclick^='CoreInvoke']").removeAttr('onclick'); }); //document ready </script> This does the trick, at least in Firefox. Also, for this page I didn't care if all of the onclick events were removed.179KViews0likes0Comments
Groups
Recent Blog Articles
No content to show