How do I change Excel from read only mode?
Click File -> Save As, select one location where you will save this document. 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.
Why is my Excel stuck in read only?
Excel spreadsheets may be Read Only due to their location. If the spreadsheet is on a network folder and you do not have appropriate network permissions to make make changes in the folder, the spreadsheet is Read Only. Spreadsheets sent as email attachments and previewed within the email program are also Read Only.
How do you remove write protection from an Excel spreadsheet?
Open the workbook that you want to change or remove the password for. On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet.
How do I unprotect an Excel sheet?
How to unprotect a cell or worksheet
- In the menu bar, click the Review tab.
- In the Protect group, click the Unprotect Sheet option.
- In the Unprotect Sheet sheet window that pops up, enter the password to unlock the worksheet, then click OK.
How do I turn off read only in Excel for Mac?
Clear the read-only status of a workbook
- Open the Finder and select the workbook you no longer want to be read-only.
- On the Action pop-up menu. , click Get Info.
- On the General pane, clear the Locked check box.
Why is a file read only?
A file that’s marked as read-only usually implies that the file shouldn’t be altered or that great caution should be taken before making changes to it. Other things besides files can also be read-only like particularly configured flash drives and other solid state storage devices like SD cards.
How do I make an Excel 2010 file read only?
Select the ‘Review’ tab. Click on the ‘Protect Document’ button, and choose ‘Restrict Formatting and Editing’. In the task pane on the right side of the window, select ‘Allow only this type of editing in the document’. Accept ‘No changes (Read only)’.