How to change read only files in excel

By Mezigal | 08.12.2020

how to change read only files in excel

How to Remove or Disable Read Only in Excel File

Sep 25,  · In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. In the General Options dialog, delete the password to modify and uncheck the box next to Read-only recommended, and then click OK. When you are back to the Save As dialog, click Save to save the workbook. Open the Finder and select the workbook you want to protect. On the File menu, click Get Info. On the General pane, select the Locked check box. Clear the read-only status of a workbook.

Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Choose where you want to search below Search Search the Community. Donna Reed Martin. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question ManuelCapiro Independent Advisor.

Hello Donna, 1. If the workbook is just marked as final to let readers to know it is final and read-only, to disable the read-only mode, you just need to open the Excel workbook and then click the Edit Anyway button on the yellow warning appeared at the top of the workbook.

In this case, to disable read-only,have a look: Open the Excel workbook. Type the password for write access and click How to calculate resistance in parallel circuits. In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options.

In the General Options dialog, delete the password to modify and uncheck the box next to Read-only recommended, and then click OK. When you are back to the Save As dialog, click Save to save the workbook. Then the read-only mode in the Excel workbook can be disabled. Once the reader attempts to change the worksheet, he will be prompted with the warning message shown below.

In this case, to disable read-only, you need to unprotect the sheet by the following steps. Open the Excel workbook. Select the Review tab and click Unprotect Sheet. If asked for the password, type it and click OK. Tips: If the password has been forgotten or lost, then you need to use VBA codes or 7-zip to unprotect the Excel sheet and disable the read-only. Hope it helps, have a good night.

How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. This site in other languages x.

Clear the read-only status of a workbook

Whether you want other people to edit your excel workbook without permission? If not, then setting your excel workbook read only is a common but good method for you to choose. If you have no idea about how to set excel workbook read only , following article would tell you several ways that you can use to restrict other people from changing your workbook.

Excel Then a message would prompt you that the settings would turn off typing, editing commands and proofing marks. So even though it could help to set excel workbook read only, it still cannot prevent people from editing. And click OK. From then on, when other people open the excel workbook, they will be prompted that the excel workbook should be opened as read-only unless they need to save changes to it.

But they still have choices to open workbook as read only or not. Then changes cannot be made to the original workbook. To save changes, you just could create a new copy of the workbook and give it a new name, or save workbook in another location. You can change workbook and save changes this time. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. It means all of workbook would be recommended to open in read only mode when you try to open them.

To directly protect workbook from editing, I think the common way is to set a modify password on it. Click Save button in Save As dialog to save workbook and replace the original one. Then while you open the Excel workbook next time, a dialog would always pops up and asks for a password for write access. Otherwise, you just could open the workbook read only. Or click Review tab and select Protect Workbook option in Changes group. Now you could also set a password to protect it, then only people who know the password could change your Excel Workbook structure.

Click OK at last. Click Review tab and Protect Sheet in Changes group. Only after removing protection, can you modify a protected cell or chart. Tips: There is another way you could also protect workbook from editing. That is encrypting Workbook with password to prevent workbook from opening.

When you cannot open excel workbook, so you cannot make any changes to this workbook, unless you can recover excel password or remove excel password. Once you have workbook open password or successfully remove open password, you would be able to do anything you want on excel workbook.

This article was helpful. Way 5: Protect sheets in Workbook to keep read only 1. Navigate to each sheet in Workbook you want to keep it read only.

2 thoughts on “How to change read only files in excel

  1. Nikom

    Did everything as in the video but it wont still delete. HELP PLEASE

    Reply

Add a comment

Your email will not be published. Required fields are marked *