Fixed : Excel Spreadsheet only open in Read-only mode on Mac

Excel sheet only open in read only mode

A lot of Microsoft Office users reported this issue. Whatever they make a new excel sheet and save it, they can’t write in this sheet the next day. It becomes a read-only file.
So, Here is the article I will share a few solutions to remove read-only privilege from an excel spreadsheet. Let’s get started.

Solution 1: Give Read & Write option

  1. Right-click on the file that you want to open.
  2. Select the Get info option.
  3. From the Privilege select tap on Read-only option.
  4. Choose the Read & Write option and then close it.
  5. Now go back to the Excel sheet and check it.

Solution 2: Use quotation symbol  

  1. You can’t use “/” in the name of your file.
  2. It allows you to save it on Mac. but windows says you can’t use a backslash (/). however once you saved it and reopen it on a Mac OS X, it will be read-only.
    To remove / from the file name or change the “/” to “-“.

Solution 3: Remove Date in your Excel File

  1. Saving the file in Excel 97-2004 (Xls) format cause this issue.
  2. It includes the date (m/d/yy) in the file name. Removing the date also fix your issue.

I hope above the solution helps to fix this problem. If you know of any other solutions, do let us via comment. And if it is useful then share it with your friends. Thank you.

Leave a Reply

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

Related Posts