Hellooooo!! So finally my blog is taking off and today I am publishing my first post! No wonder I am so very excited. I do not want to make this post too long and so I would not be discussing about myself or MadAboutExcel here. Instead, I would request you to visit the About page of MadAboutExcel. There you will find all that you would need to know about me or this blog. So please make sure you check that out. So let the fun begin…
In this first blog post, I would like to give a solution to a problem faced by many users of MS Excel – the problem that all downloaded excel documents open in Protected View i.e. you cannot edit the document unless you click on the annoying ‘Enable Editing’ button displayed just under the Main Menu.
If you always need to click the Enable Editing button to be able to edit an excel document you will agree that it is a pain! So let me help you get rid of this frustration once and for all.
Excel documents downloaded from the Internet including emails and from other potentially unsafe locations may contain viruses or other kinds of malware that can harm your computer. To help protect your computer, excel documents originating from these potentially unsafe locations are opened in Protected View.
By using Protected View, you can read a file and see its contents but you cannot edit them. While it’s easy enough to click the Enable Editing button at the top of the screen when you want to make changes, it can be really annoying to do that every single time you open an excel document.
Here is how you can remove ‘Enable Editing’ button:
1. Click the File Tab.
2. Select ‘Options’
3. Select ‘Trust Center’ from the dialogue box
4. Click on ‘Trust Center Settings’ button
5. Select ‘Protected View’
6. Uncheck all three options
7. Click Ok
Now if you open any excel document, it will open in Edit mode and will not show the Enable Editing button.
Now all these steps will work only if your system administrator will allow it. You may find that in the system provided to you by your company all the described options are disabled, but when you open excel you still get the Enable Editing button. This is because in an office environment the macro settings may be disabled for security reasons, and so you may have no choice but to manually accept editing and the enable editing options every time.
Please try the above steps and post a comment to tell me if this post helped you to get rid of the annoying ‘Enable Editing’ button.
I would be publishing some really cool excel tutorials in the days to come that can surely help you get a lot better in Excel. To get updates on all such content please make sure you subscribe to the MadAboutExcel newsletter using the opt-in form that you can see right below this post.
Hope you have enjoyed today’s lesson. Have a great day, keep calm and excel in life. Thank You!
GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE
Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!
Thank you for subscribing.
Something went wrong.