If you are unable to edit the Excel file online or in a read-only mode, then in this guide we will show you potential fixes to rectify this issue. This spreadsheet software from Microsoft does more than just dealing with data. For example, you could carry out various calculations, insert graphical tools such as pie charts, pivot tables, Macros, among others. Likewise, it also supports collaborative features. As a result, you and your co-workers can carry out the editing on the go. However, to make use of this feature, you will have to switch over to the Excel web version.
For the unawares, this online version of the software holds near about all the functionalities that the standalone app has to offer. Plus the added advantages that you don’t need to download the additional software app makes it the go-to choice for many. Then as mentioned before, its live collaborative features stand out as its USP. However, not everyone is able to make full use of this feature as they are unable to edit the Excel file online or in a read-only mode. If you are also facing this issue, then this guide shall come in andy. Follow along for the instructions.
Also Read
How to Fix Can’t Edit in Excel Online / Read-Only mode
Quite a few users have already voiced their concerns regarding this issue across the Microsoft Support Forums. With that said, given below are few potential fixes for the same. Since there isn’t any universal fix as such, you should try out all the methods given below until you are able to achieve success.
Fix 1:Re-Verify the File Permissions
While it is mostly along the obvious lines, yet it has been seen as the most frequent reason for this issue. Many times the owner of this file forgets to enable the editing functionality of the shared file. As a result, you are left with no choice apart from viewing its contents. So to gain back the editing rights for your file, you might have to grab the file owner’s attention towards the below steps:
- The file owner should go to the File section from the top menu bar.
- Then head over to the Share option and select the Share with people option.
- Now make sure that the permission is set to Anyone with the link can edit.
- If that is not the case, then click on this permission and check-mark the Allow Editing option.
