Hi @Tejaswini V,
Per my test, you will need to open the workbooks with Excel Desktop app, but not from the Browser.
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.