Hi,
I was always able to open Excel documents that were protected (read only).
Is your protected file set to read-only or other protection settings, such as sensitivity label, password to open the file?
Please share us with a screenshot of the message.
Could you please check the Office product name and product version number?
To get this information, you may click one Office app > File > Account > Product Information
.
At current time, I suggest you roll back Office to earlier version for a check. Reference: How to revert to an earlier version of Office
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.