How To Remove Read-Only From SharePoint Excel

Removing the read-only restriction from Excel files in SharePoint is essential to make changes and collaborate effectively.

To remove the read-only restriction from Excel files in SharePoint, there are a few methods you can try:

Method 1: Select “No” when prompted to open the Excel worksheet as read-only. Then, choose “File”, followed by “Save As” and “Browse”. Click “Tools” at the bottom of the Save As menu and choose “General Options”. Under “General”, find the “Read-only Recommended” check box and uncheck it. Click “OK”.

Method 2: Close the Excel workbook, right-click on the specific workbook, select “Properties”, uncheck “Read only”, and click “OK”.

Method 3: Check if the files are saved to OneDrive or SharePoint. Co-authoring files is only possible when they are saved to these platforms.

Method 4: In SharePoint Server, check if the Excel files have Checkout, Required, or Validation columns or metadata, or if the Draft Item Security setting is enabled. These can cause the files to be synchronized as read-only.

Other considerations: Make sure the antivirus program is not opening potentially unsafe files as read-only. Activate the Office license if it’s not already activated. Check document properties to ensure the Read-only attribute is not checked.

It is also important to note that using the co-authoring feature in SharePoint allows multiple users to collaborate on Excel files simultaneously, avoiding the read-only issue.

Methods to Remove Read-Only in SharePoint Excel

There are several ways to remove the read-only restriction from Excel files in SharePoint, allowing you to edit and save them effortlessly. Here are four methods that you can try:

  1. Method 1: Select “No” when prompted to open the Excel worksheet as read-only. Then, choose “File,” followed by “Save As” and “Browse.” Click “Tools” at the bottom of the “Save As” menu and choose “General Options.” Under “General,” find the “Read-only Recommended” check box and uncheck it. Click “OK.”
  2. Method 2: Close the Excel workbook, right-click on the specific workbook, select “Properties,” uncheck “Read only,” and click “OK.”
  3. Method 3: Check if the files are saved to OneDrive or SharePoint. Co-authoring files is only possible when they are saved to these platforms.
  4. Method 4: In SharePoint Server, check if the Excel files have Checkout, Required, or Validation columns or metadata, or if the Draft Item Security setting is enabled. These can cause the files to be synchronized as read-only.

It is important to note that removing the read-only restriction is not the only consideration when working with Excel files in SharePoint. There are a few additional factors to keep in mind:

  • Make sure your antivirus program is not opening potentially unsafe files as read-only.
  • Activate your Office license if it’s not already activated.
  • Check document properties to ensure the Read-only attribute is not checked.

Furthermore, leveraging the co-authoring feature in SharePoint allows multiple users to collaborate on Excel files simultaneously, avoiding the read-only issue. This feature promotes teamwork and enhances productivity when working with shared documents.

To summarize, these methods will help you remove the read-only restriction in SharePoint Excel, giving you full control over your files and enabling seamless editing and saving. Consider these techniques and additional considerations to optimize your experience with Excel files in SharePoint.

Method Instructions
Method 1 Select “No” when prompted to open the Excel worksheet as read-only. Then, choose “File,” followed by “Save As” and “Browse.” Click “Tools” at the bottom of the “Save As” menu and choose “General Options.” Under “General,” find the “Read-only Recommended” check box and uncheck it. Click “OK.”
Method 2 Close the Excel workbook, right-click on the specific workbook, select “Properties,” uncheck “Read only,” and click “OK.”
Method 3 Check if the files are saved to OneDrive or SharePoint. Co-authoring files is only possible when they are saved to these platforms.
Method 4 In SharePoint Server, check if the Excel files have Checkout, Required, or Validation columns or metadata, or if the Draft Item Security setting is enabled. These can cause the files to be synchronized as read-only.

Additional Considerations for Read-Only Removal in SharePoint Excel

Apart from the main methods discussed earlier, there are a few other factors that may affect the read-only restriction in SharePoint Excel files, and they should be taken into consideration for a seamless editing experience.

Firstly, it is important to ensure that your antivirus program is not treating Excel files as potentially unsafe and opening them in read-only mode. Check your antivirus settings and make sure that the files are not being marked as read-only.

Secondly, if you haven’t activated your Office license, it may be causing the read-only restriction in SharePoint Excel. Activate your Office license to gain full control over your documents and remove any restrictions.

Additionally, it is worth checking the document properties of your Excel files. Sometimes, the Read-only attribute may be checked, causing the files to open in read-only mode. Make sure to uncheck this attribute to enable editing.

Lastly, if you are collaborating with others on Excel files, consider using the co-authoring feature available in SharePoint. This allows multiple users to edit the same document simultaneously, eliminating any read-only conflicts and enhancing collaboration.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.