If you're the owner of the file, this is a fairly simple process Edit and save your files effortlessly. Click the 'edit anyway' button to remove the 'read only' settings. Understand the reasons and how to fix it. The author of an excel 2016 workbook may protect the sheet and lock the cells so that users only can open and read the workbook but can't be able to make changes to it Once the reader attempts to change the worksheet, he will be prompted with the warning message shown below.
Opening an excel document only to find it in 'read only' mode can be a bit annoying, right You're all set to update your data or tweak a formula, and suddenly, excel decides to play hard to get But don't worry, changing an excel document from read only to edit is not as tricky as it seems. Here's how to do it
OPEN