Learn how to configure Egnyte’s integration with Microsoft Office (Limited Availability), which allows users to co-edit files using the desktop versions of Microsoft Word, Excel, and PowerPoint. Enabling Co-Editing in Microsoft Office Desktop Applications. On the Message Bar, click Enable Editing. Exit Protected View and edit when the red Message Bar appears Click File Edit Anyway. Caution: We recommend you only do this if the file's source and content are trusted by you. Unprotect Excel sheet with VBA code (works for Excel 2007 and earlier) 1. Open the Excel file, press the keys 'Alt + F11' on the keyboard to bring up Microsoft Visual Basic for Applications. Click on 'Insert', and select 'Module'. Copy the VBA code and paste to the module box. If you're part of the Teams public preview, you can choose the default way to open and edit Office files. Continue to open the file directly in Teams (default), open it in the web browser, or open it in the Word, Excel, or PowerPoint desktop apps. From the More options menu next to a file, select Open Change default. Open any Office 2010 application (Ex: Word or Excel). Click on Office or File button, and select Options. Under Options select “Trust Center” in the left pane. Click on Trust Center Settings in the right pane. Click on the Protected View in the left pane of “Trust Center” window.
Are you stuck looking for how to enable editing in Excel read-only? Have you tried multiple options and still found yourself in the same loop? Worry no more because we have good news for you. To access the file in an editable mode, you need to perform some operations on the Excel file. These processes vary depending on the type of protection in question as discussed in detail in this article.
Part 1: Directly Disable Protected View to Enable Editing in Excel
When you try to open a downloaded file in Excel, the worksheet will automatically open in a read-only mode meaning you can only view but you cannot edit or apply other commands. In this case, there are plenty of ways to disable protected view in order to enable editing on your Excel file. One of the most straightforward options is to do it directly via program settings. This method will open the Excel file in editable mode and prevent it from displaying protected notification every time you open the file. This helps to save the time required to disable the protected view every time you open the Excel file. To disable the protected view directly, follow the steps below.
Step 1: Double-click the Microsoft Excel icon on your desktop to access the primary interface. Once opened, navigate to 'File' and choose 'Options' from the subsequent list.
Step 2: From the displayed 'Excel Options' window, choose 'Trust Center' > 'Trust Center Settings' on the bottom left pane.
Step 3: Click on the 'Protected View' and then uncheck any or all of the protected view options given. Once satisfied, click 'OK' to directly apply the settings.
Part 2: Other 4 Ways to Enable Editing in Excel Read Only
Protected View is one of the most common situations you will meet if you download files from the Internet. Of course, you will also encounter some other cases where you need to enable editing in read-only Excel file. In this section, we will list 4 common cases and solutions as well.
Case 1. Excel File is Marked as Final
How to know that your Excel file is Marked as Final? When you open a read-only Excel file Marked as Final, there is a yellow notification on top of the Excel worksheet. This notification is a warning that the author of the Excel file has denied you to edit the Excel sheet. This means you can only read the contents of the workbook but not perform operations like typing, editing, and engage proofing marks and commands.
In order to edit the Excel file Marked as Final, you need to get rid of the read-only feature. This is simple as you can simply click the 'Edit Anyway' button within the 'MARKED AS FINAL' notification at the top of the worksheet.
Case 2. Excel File is Recommended as Read Only
In the case where you open an Excel file recommended as a read-only, it is usual to get a pop-up window asking you to open the file in read-only mode. Selecting 'Yes' will open the file in read-only mode and you cannot apply any changes. However, if you want to make any changes to this file, choose 'No' instead.
Now if you want to remove read-only recommended feature for good, then do the following.
Step 1: Open the Excel file recommended as read-only and select 'No' from the pop-up window.
Step 2: Navigate to 'File' then choose 'Save As' to open the file directory. Click the drop-down icon beside 'Tools' at the bottom of the file explorer window and select 'General Options'.
Step 3: The 'General Options' window will open. Locate and uncheck the 'Read-only recommended' box. Click 'Ok' to complete the removal of the read-only recommended mode on your Excel file.
Case 3. Excel File is Protected with Modifying Password
If you try to open an Excel file that is protected with a modifying password, a pop-up window asking you to enter the password will appear. In this case, it is really easy to enable the editing mode whether you know the correct password or not.
If you know the correct password, just type it within the prompt. Then go to the 'File' option and select 'Save As' from the subsequent list. Delete the password in the 'Password to modify' field in the 'General Options' dialogue box. Now, you will receive a Excel file without protection.
If you don't know the correct password, then the only option for you is to open this Excel file in the read-only mode. After opening, press 'Ctrl+A' to select the whole worksheet and then press 'Ctrl+C' and 'Ctrl+V' to copy the content to a new worksheet. You can edit the new worksheet as you wish now!
Note
This method only works when you can select the content. Sometimes, you are not allowed to select the cells if the 'Select Locked Cells' and 'Select Unlocked Cells' options are forbidden by the owner. If this is the situation, you can try the solution in Case 4.
Case 4. Excel Worksheet is Protected with Password
In this case, you won't know that the worksheet is password protected until you want to select or edit some cells. An 'Unprotect Sheet' dialog box will pop up requiring you to enter a password. Different from the above 3 cases, an Excel worksheet protected with a password can only allow you to open the file in editable mode if you know the password. The only way that is easy to use and 100% workable is by using a password remover tool.
Passper for Excel is the best password remover tool for Excel worksheets or workbooks. By using Passper for Excel, you do not have to be a tech-savvy since it is really easy to use. With one simple click, all restrictions can be removed with 100% success rate. Additionally, Passper for Excel is helpful to recover opening password for all types of Excel file.
Passper is a sub-brand of the hi-tech corporation iMyFone, which has been trusted and recommended by many professional websites like Cnet, Cult of Mac, etc. Before you decide to use this program, you can also check the user's feedback below.
Now follow the simple steps below to enable editing in your Excel file. Start by downloading and installing the program on your computer or laptop.
Step 1 Open Passper for Excel on your PC to access the main interface. Choose 'Remove Restrictions' option.
Step 2 Click on the 'Select a File' button to upload your password protected Excel file. Once the restricted Excel file has been successfully uploaded onto the program, simply hit the 'Remove' button to activate the removal process.
Step 3 The process is super-fast and will take about 2 seconds to complete. When it is successfully completed, the program will display a success notification. Your Excel file is now restrictions-free and you can freely edit it.
Conclusion
As you have seen from the information above, it is clear that there are several options for enabling editing on read-only Excel worksheets or workbooks. After reading this article, you can easily edit your protected Excel file no matter what the case is. If you have any doubt about the above solutions, you can turn to the comment section below and leave us a comment. We will try our best to help you!
To enable or disable the AutoFormat feature and options in Microsoft Word, follow the steps below for the version of Word on your computer.
Microsoft Word 2007 and later
- Open Microsoft Word.
- Click the File tab.
- Click the Options link in the left navigation pane.
- In the Word Options window, click the Proofing option in the left navigation pane.
- Click the AutoCorrect Optionsbutton.
- In the AutoCorrect window, click the AutoFormat tab.
In this section, users can enable or disable each of the AutoFormat features they do not want to use.
Microsoft Word 2003 and earlier
- Open Microsoft Word.
- In the menu bar, click Format and select AutoFormat.
- Click the Options button.
In this section, users can enable or disable each of the AutoFormat features they do not want to use.
Additional information
Enable Editing On Microsoft Word Document
- See the AutoFormat definition for further information and related links.