Unable to open Excel files from SharePoint on Office 365 cliente

Flórida da Graça Botelho Araújo 201 Reputation points
2022-12-29T12:51:31.413+00:00

Hello.

Can anyone help with the origin of this problem and possible solution?

In SharePoint 2016 portal, there are users with read access to a library, but the option "Open in the client application." for office files does not appear (image below).
I have checked the library settings and it is ok (Set to "Open in the client application.")

User 1 (User1.png) has read access and both options appear when clicking on an excel file
User 2 (User2.png274834-user2.png) has read access and only the "open in browser" option appears

The client application is office 365.

thanks

Microsoft 365 and Office | SharePoint | Development
{count} votes

1 answer

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,601 Reputation points
    2022-12-30T09:36:35.557+00:00

    Hi @Flórida da Graça Botelho Araújo ,

    • Make sure you have activated “Open Documents in Client Applications by Default” Feature.
      Go to Site Settings >> Site Collection Features, click on the “Activate” button next to the “Open Documents in Client Applications by Default” feature
      274929-image.png
    • Please switch the browser to check if the same problem exists or enable the IE mode of the Edge browser.
    • Compare the versions of the two users' office clients and update it.
    • Try disabling Office Web Apps for SharePoint environment, go to SharePoint WFE or Application Server and open SharePoint Admin Shell. Run the following PowerShell command to disconnect the Office Web Apps farm from SharePoint by removing the binding. See if Excel files will be opened by default on the client side.
      Remove-SPWOPIBinding -all $true

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.