Removing Excel file password 2010

Posted on 2012-03-12
Medium Priority
Last Modified: 2016-09-22
I have the password for the document and would like to remove it. How do I do this?

Most boxes are grayed out, when trying to remove.
Question by:usliee

Accepted Solution

xeroxzerox earned 1500 total points
ID: 37711350
1.  On the Review tab, in the Changes group, click Unprotect Sheet.
      Note  The Protect Sheet option changes to Unprotect Sheet when a worksheet is    
2.   If prompted, type the password to unprotect the worksheet.

Expert Comment

by:Elmar Koschka
ID: 37711351
Remove Share document then you can remove password.
LVL 45

Expert Comment

ID: 37711394
If you have the password, you can do it with above steps, else not
LVL 50
ID: 37711732

The file password can be changed or removed this way:

File > Save As > Tools dropdown > General Options

cheers, teylyn

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question