[Fixed!] This Excel Workbook Was Opened in ReadOnly Mode
This Workbook Was Opened In Read-Only Mode. It is the most common cause of this error. Follow these steps to fix this error.
[Fixed!] This Excel Workbook Was Opened in ReadOnly Mode
Workbooks.open filename:=filepath, readonly:=true or, as pointed out in a comment, to keep a reference to the opened workbook: Web 10 possible solutions: On the file menu, click info. I've logged out of office 365, cleared caches and cookies, and restarted browser, nothing changed. Dim book as workbook set book = workbooks.open (filename:=filepath, readonly:=true) share follow edited. Follow these steps to fix this error. Remove read only property if the file is already set as read only in its property it should be a read only file. Web alex gordon 56.7k 287 670 1056 add a comment 2 answers sorted by: I never used to have this issue. You may need to check with your antivirus provider to learn how to adjust these settings.
I've logged out of office 365, cleared caches and cookies, and restarted browser, nothing changed. For stronger protection, require a password to save changes. I've logged out of office 365, cleared caches and cookies, and restarted browser, nothing changed. On the file menu, click info. Follow these steps to fix this error. Workbooks.open filename:=filepath, readonly:=true or, as pointed out in a comment, to keep a reference to the opened workbook: Web 10 possible solutions: Web 06/28/2022 8 contributors applies to: Remove read only property if the file is already set as read only in its property it should be a read only file. It is the most common cause of this error. Besides, do you open the files from excel desktop application?
