Excel's Protect Sheet and Protect Workbook, Word's Restrict Editing and PowerPoint's password to modify all stop a file being changed, but none of them encrypts it. The protection is a setting stored inside the file next to the content, with the password kept only as a check. This tool finds every one of those settings in the file, lists them, and saves a copy without the ones you tick. Because the setting is removed rather than the password worked out, it does not matter how long or complicated the password was, and it takes a moment rather than hours.
Only the protection settings change. Cells, formulas, formatting, charts, comments, macros and everything else in the file are copied across as they are. If the file also has an open password, the kind that encrypts it, the tool asks for that password and saves a copy without it; it cannot open such a file without the password, and never tries to guess one. The files are read and rewritten in your browser and never uploaded.
- How can it remove the protection without knowing the password?
- Sheet and workbook protection does not encrypt anything. Excel stores a setting saying the sheet is protected, together with a scrambled form of the password to check against when someone types one. Excel itself honours the setting, but the cells are stored as normal. Take the setting out and Excel has nothing to ask for. The same goes for Word's Restrict Editing and the password to modify in all three programs.
- Can it remove a VBA macro project password?
- Yes. The code behind a workbook (opened with Alt+F11) can be locked for viewing with its own password, separate from sheet and workbook protection. Like them, it is not encryption: the macro code is stored normally, with only a setting and a scrambled form of the password kept beside it. The tool rewrites that setting to “no password”, exactly as an unprotected project is stored, so the project opens in the VBA editor without one. The macros themselves — every line of code — are copied across untouched and still run. It works on macro-enabled files (Excel .xlsm, .xlam, .xltm and .xlsb; Word .docm and .dotm; PowerPoint .pptm, .ppsm, .potm and .ppam) and on old .xls workbooks.
- Can it remove the password that is needed to open the file?
- Only if you know it. A file with an open password is encrypted, and the password is the key, so there is no setting to remove. Type the password and the tool decrypts the file in your browser and saves a copy without it, so you are not asked for it again. That works for .xlsx, .docx and .pptx from Office 2007 onwards and for .xls from Excel 97 to 2003. It does not guess or recover open passwords.
- Is this allowed?
- It is meant for files you own or have the right to edit: a workbook you protected yourself and lost the password to, or one handed down by a colleague who has left. Editing protection is a guard against accidental changes, not a security feature, which is why removing it takes no cracking. If a file belongs to someone else, ask them.
- Will anything else in the file change?
- No. The tool takes out the protection settings and copies everything else across: values, formulas, formatting, charts, pictures, comments, defined names and macros. Hidden sheets stay hidden: once the workbook structure is unlocked, unhide them in Excel by right-clicking a sheet tab and choosing Unhide.
- Which files does it work with?
- Excel .xlsx, .xlsm, .xlam, .xltx, .xltm and .xls (Excel 97 to 2003); Word .docx, .docm, .dotx and .dotm; PowerPoint .pptx, .pptm, .ppsx, .ppsm, .potx, .potm and .ppam; and LibreOffice or OpenOffice .ods and .odt. The password that locks a VBA macro project is handled too, in the macro-enabled formats and in old .xls workbooks (see the question above). In Excel binary workbooks (.xlsb) only the VBA macro project password is removed; their sheet and workbook locks, old Word .doc files and old PowerPoint .ppt files are not handled yet: save them in the newer format first.
- Why does my old .xls open without a password, when it is protected?
- When the structure of an .xls workbook is protected, Excel encrypts the file with a built-in password, "VelvetSweatshop", and opens it without asking. The tool does the same, so these workbooks are unprotected without a password too. The copy it saves is not encrypted.
- Are the file or any password sent anywhere?
- No. It is read and rewritten by your browser on your computer, and so is any password you type. Nothing is kept once you close the page.