Have you ever met one or all of these conditions below?
- You got an Excel file but you couldn’t modify the cells’ value or the whole of its content?
- You got an Excel file but you couldn’t see any header (rows and column address)?
- You got an Excel file but you couldn’t access some menus or features on the ribbon / toolbar?
- You got an Excel file but you couldn’t set the printing parameters such as the printing area, margins, repeated row or column, etc.?
It must be so annoying, right? And, actually, how could this happen? Yeah, you got a protected Excel file! And then, how to unlock its protection? Here is the way out:
For almost 2 years recently, I always use Excel Password Remover to remove any protection within the sheet or workbook of protected Excel files. This password remover is actually a macro file that needs to be loaded to your Excel every time you want to unlock your files. It will appear as an add-in in your application.
Excel password remover in brief….
Excel password remover is a tiny macro file from Straxx. Basically, it’s a free stuff, but will be cost $26 for the pro version which can open sheet and workbook protection at once.
This program removes the password protection applied by the “Protect sheet” and “Protect workbook” commands in Excel (i.e. enables you to edit the workbook even if you have forgotten your password). It will remove passwords of any length, also passwords containing special characters.
NB! This program can’t remove file protection, i.e. if you are asked for a password when opening your workbook, this program won’t help you.
For the pro version, you will get benefits as follow:
- The password is displayed (a password that works, but most probably not the original one)
- One command removal of all sheet and workbook structure protection passwords in the active workbook
- No annoying pop-up when you start Excel with Password Remover PRO
- No expiration date. (The free version must be upgraded at the end of each year)
- Removal of sharing password (on demand only)
- Legal for business users
How to use it
To use this tiny tool, we just need to open the <.xlam> file from Excel. This will make you get a warning like this:
Just click on Enable Macros button and you will get new menu on your ribbon like this:
After this menu appears, you can then open your protected file. Click on Unprotect sheet or Unprotect workbook depends on your need. It usually takes a few second to open the protection and then you can directly edit your workbook’s contents.
So easy, isn’t it?
Why don’t you try it by yourselves?
It’s totally worth to try, because it’s very useful stuff that we will need. I always use it to help my friends who want to edit their protected Excel files from their office before they print them all. It’s true that it’s really annoying to load the <.xlam> files every time I need to open the protection, but it only costs seconds to do it. And moreover, it’s free. Its function makes it greater than the effort to load it. Trust me.