Lock Excel file to edit only in browser

IMK 421 Reputation points
2021-02-22T18:07:29.887+00:00

Hi

Is it possible to lock excel file so, that users can edit it only in browser or via Teams (desktop or browser) and not in desktop excel at all?

Excel file itself is sitting in Sharepoint site document library and the the site is Teams team site.

We would like this because often with several users editing in desktop excel, modifications can not be combined and excel creates several copies of the file. We would like to get rid of several copies with browser (or via Teams) editing only.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,074 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Jerry Xu-MSFT 7,936 Reputation points
    2021-02-23T06:52:39.88+00:00

    Hi, @IMK ,

    Per my test, we cannot stop users from opening files in client application. We can set the default open behavior to be opening files in browser. However in browser, still users can switch to client application.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments No comments