Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Remove Document Password In Excel 2010

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a document that was created in Excel 2010 and requires a password to open. How do I remove the password so that it is no longer required?

View Answers     

Similar Excel Tutorials

Password Protect Excel Files
How to keep an Excel workbook safe by encrypting it with a password. This will make it so that a user cannot open ...
Remove Personal Information from Excel Files
How to remove all personally identifiable information from an Excel file. When a file is created in Excel, it auto ...
Remove Vlookup #N/A Error in Excel
How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup ...
Prevent a User from Changing Any Data in Excel
I'll show you how to lock a spreadsheet so that nothing can be changed in it. This is a great feature to use when ...

Helpful Excel Macros

Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a passwor
Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
- Excel macro that will remove/delete all of the comments from an entire Excel workbook. This means that this macro will

Similar Topics

I have an old MS word document that I set to prompt for password for it to open. Unfortunately I cant remember the password and have tried all the passwords I've been using as far as I can remember. Tried the password recovery tools in the web but to no avail.
By any chance how can I remove the password so that I could open the document anew.


I protected a special document with a password so noone could see, including me. I typed in what I thought the password was and no luck.
Does anyone know of a way to bypass the password check, remove the password and access my document?
It would be a great saver...


Hey Guys,

Our company is using sharepoint, so we no longer need to keep passwords on our excel files. Also, we just recently upgraded from 03 to 07. However, we can't find out how to remove the workbook password in excel 07. To be clear, Im not talking about the password to let you edit items in the sheets and what not. Im talking about the password you are prompted for BEFORE the workbook is even opened! It will say "test.xls is reserved by JSA715 Enter password for write access, or open read only."

I've tried all of the password options under the review tab, none of them work.


Hi All,

I have an MS Excel 2010 xlms file which is password protected. Unfortunately, the person who has the password has left the company!

Which is the best tool to remove the password / recover the file? I don't mind paying a premium (doesn't have to be free) and from a reputable source.

Many thanks,

I am using Excel 2003.

I have a workbook with password protection for opening. When I open it, Tool>Option>Security shows the password as asterisks. I remove them. I then SaveAs and under Tools, General Options, Remove the Asterisks for Password to Open. I then continue with the save.

Then I check that the password has been removed, but it has come back.

I have put an Exit Sub as the first line of my Before_Save code so I know that the code is not doing anything.

Does anyone know what stops me from removing the password to open the file.

Right, I've saved a document but cannot open it - I've forgot the password. can anyone point me in the right direction to remove the password. I've looked on Google and there are plenty of programs at about $60 which will do this, but I dont really want to pay that much for one document.

Thanks in advance, or if someone is kind enough to offer to remove for me - EDIT: Removed e-mail address I can mail.



I have a VBA project coded by one of my co-workers who left our company last month. He however gave me the password to open the project before he left. Now I think this VBA project no longer needs protecting, therefore I want to remove the protection. I know for an Excel worksheet, it is very easy to remove the protection if you know the password and want to remove it. Simply open the Excel workbook by using the password and then go to tool --> option --> security ...

Is there an easy way to remove the protection for the VBA project because I have already had the password?

Thanks for help!!!



I'm hoping someone can help me here! I have an Excel document that is viewed by approximately 200 users. For obvious reasons I only want them to have read only access however I use and update the document regularly throughout the day.

Previously when the document was on Excel 2003 I would go to Tools/Options and select from there to add a Password to either Modify or Open.

I'm now using Excell 2007 and I can't seem to find the same function. I know there is one section when saving a document as "Save As" that will allow me to do this however I don't to have to create a new document every time I add a password. Likewise I know I can go onto my drive and right click the document to "Read Only" but this seems a bit of a clunky way round it rather than just adding a password.

The Microsoft help pages say to go to menus that don't exist so I'm a bit confused!!

Hi All,
I Have a macro enabled workbook and i am trying to set it that only people with the password can open the file, I can set the password for modifying the file but when i set it for opening the file, i get this message;

"This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to password protect or restrict permission to this document, you need to remove these macros."

But i cannot remove these macros as they are integral to the sheet...!!!

Please help!!!

Hi, I accidentally placed a password in my workbook. Now, every time I open the xlsm file, it requires me to input a password. (thankfully i was able to guess the password.) I tried protecting and unprotecting the workbook using the one under review tab, but it's still there. This happened after tinkering the macros. Any ideas?

Dim x
x = Inputbox("Type your password here.", "Password Required")
If x = "" Then Exit Do
Application.ScreenUpdating = True
x = pswrd("Type your password here.", "Password Required")
Loop Until x = "password" Or x = False

Always always it'll never take the correct password the first time. Ive tried the until right after the do but then I can't get out of it (by canceling or not entering anything).

I can't seem to see through my own created fog to see the problem. Can anyone help me?

I have created a worksheet some time ago and protected certain cell within it
and gave the worksheet a password in order to edit it. Unfortunately I can
no longer remember the password and to save me creating the worksheet again
it would be better if there was a way round this or a small program that will
remove the password for me. Your help is appreciated.

I found a function to set the password a an excel file:

Function SetPwd(strNoPwdFile As String, _
strPwdFile As String, _
Optional strOpenPwd As String, _
Optional strModPwd As String) ' As Boolean
' This function requires the following arguments:
' strNoPwdFile - The path to a document without a password.
' strPwdFile - The path and name to save the password-
' protected document.
' This function accepts the following optional arguments:
' strOpenPwd - A case-sensitive password required to open
' the document.
' strModPwd - A case-sensitive password required to modify
' the document.
On Error GoTo SetPwd_Err
Documents.Open FileName:=strNoPwdFile
With ActiveDocument
.SaveAs FileName:=strPwdFile, _
Password:=strOpenPwd, _
End With
SetPwd = True

Exit Function

MsgBox "Error #: " & Err.Number & vbCrLf _
& Err.Description

Resume SetPwd_End

End Function

And I have the following visual basic code to call the function :

Sub main()
End Sub

But the compiler said that it is syntax error.

How can i rectify the error ?

I have an excel spreadsheet which when I try to remove the workbook protection asks for a password. Unfortunately I have forgotten the password. I have downloaded numerous software which claim to be able to remove the password but as yet none of them have worked. Can anybody help?


I am new to this site. I did not find anything this fit under, so I am very sorry if this in the wrong section to post. I have an spreadsheet in a .xlsx format with a password on it. No other sites are helping because they all know the password and just want to disable it. I can't even look at the document, and I don't have the password. Nothing else is related to my case that I found, so I need help getting the password off. I use office 2010 for this file format. Please reply fast. I am good with computers and know a lot more than a lot of people, but please don't get technical on me, I'll get lost.

Thanks for the help,

Hy everyone,
I need help.
I want to make vba code that will set up password protection for opening word document, also that key for opening should be written on the document, because document is suposed to be printed and then taken to someone who would have to open the same document on some shared server and add some text. only person who get the document physicaly should be able to open the same document on web.
I have never programmed before in vba, and i would aprecieate any help.

I have a master document which maintains employees vacation an lieu time. I want to create a document for each employee where they can view all of their own person information by linking it to the master. The only problem is is that the master document is password protected. They can't have the password or they could access the master document and other employees confidential information. Is there a way to update there own document without entering the password or codon so the password automatically enters without them seeing it.

Good morning.

I created a workbook that i originally wanted to have a password, but since it has been moved to a secure location, i need to know how to remove the password protection from the sheet.

I have the password but just don't want to punch it in every time i open the workbook



Hi all,

I have a a macro that opens password protected documents on a network folder, applies the password, copies the contents to another workbook and then closes the protected document.

This all works perfectly when the workbook on the network folder is closed. However, when another user has that document open I get promoted to apply the password in order to open the workbook in 'read only' mode. Once the password is applied the macro continues with the copy/close process perfectly.

I would like to eliminate the step of manually applying the password if the document is open by incorporating it into the macro. Is this possible?

This is my macro at the moment:

Please Login or Register  to view this content.

Thanks for any advice.

My boss gave me an excel document with sensitive payroll information about all our employees in it. I want to password-protect the document so nobody else in the office can open/modify it.

For whatever reason, in the Save As dialog box undre General Options, the option to set a password for opening the document is disabled. Interestingly, the option for setting a password for modifying it is still there, but the one for opening the document is greyed out.

Another interesting characteristic about the document is that the option to Protect Sheet is disabled (2 sheets in the workbook - both are disabled from protection).

There are no macros defined in the workbook and I'm using Excel 2007. Any ideas greatly appreciated.

Can't Remove password protection
I inserted the following code into one of my workbooks to password protect the document before closing which works great, however when I reopen the workbook I type in the password the workbook opens and then I try to remove the protection but it is stuck and in the protection it keeps saying that the workbook isn't protected. I then removed all macro code from the workbook and saved it as a different file name however it still stays protected and there is no way to remove the protection, can someone please help with this.

Application.DisplayAlerts = False
ThisWorkbook.Password = "jaye"
Application.DisplayAlerts = True
ThisWorkbook.Saved = True

There is a database that we want to modfied, but the creator no longer works
for our company. She password protected the document. Is there away to
overide the password?

Mr. Excel,

Am attempting to create a macro that requires the password "OPEN", before going from the current sheet (Instructions), to Sheet1.

currently using:

Sub SheetPassword()
Var1 = InputBox("Enter Password in this Input Box :", _
"Required Password", "OPEN")
On Error Resume Next
End Sub

Getting message: Compile Error, Expected End Sub.

Thank you in advance,

Can any one help me on how to remove password from xls file to open it. I have the file which is password protected. I forget the password. Any suggested free/trial software?.

Hi all,
I'm using a online submitted Excel speadsheet using as calender which is PASSWORD protected. Now I want to remove the password which I don't know how to do.

Can you help me?

Thanx in advance.