Normally when you open a file from network, you will see words saying "We opened this workbook read-only from the server" then you just need to click on "Edit Workbook" to edit it. But for unknown reason, this is not showing. I have to go to File > Info >

Tejaswini V 0 Reputation points
2025-01-03T05:28:18.6133333+00:00

I want this edit workbook tag to show as soon as I open excel. Please help me to add it back.

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,628 questions
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 37,546 Reputation points Microsoft Vendor
    2025-01-03T09:32:52.03+00:00

    Hi @Tejaswini V,

    Per my test, you will need to open the workbooks with Excel Desktop app, but not from the Browser.

    User's image

    And you could follow the steps to enable Read-Only Attribute, please make a reference

    https://www.exceldemy.com/excel-this-workbook-was-opened-in-read-only-mode/


    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 Answers by the question author, which helps users to know the answer solved the author's problem.