Industry guru Dave Taylor offers free tech support on a wide variety of technical and business topics, including HTML, Apple iPhone, online advertising, Cascading Style Sheets, Web design, management, Unix, Linux, search engine optimization, online dating, Mac OS X, shell script programming and Microsoft Windows.

How to remove password protection from a Microsoft Excel worksheet file?

I have a spreadsheet that I created a while back with both an open and modify password but now want to share it with someone without a password blocking access. How do I turn off the password protection in Microsoft Excel for Mac?


Dave's Answer:

I imagine it'd sound flippant if I just said "you remove password protection from an Excel file the same way you set up the password protection in the first place" so I will resist saying that. Okay? :-)

Seriously, it's a bit weird to remove the password because there's no feedback or indication that it's been removed: all you do is delete the previously entered password when you're doing a 'Save As' save.

The best way, however, is to step through the entire Security section on your document, so let me show you how to do that. The very first step is to open up the Excel spreadsheet in question, then go to Preferences:

Microsoft Excel for Mac OS X: Preferences

You may be surprised if you've never poked around in the Excel preferences, there's a lot you can access:

Microsoft Excel for Mac OS X: Preferences Window

You can explore later, however. Right now, let's stay on task! Click on "Security", and ...

Microsoft Excel for Mac OS X: Preferences: Security

Now you can set a password for opening or modifying here by simply typing one in. Since I already have a password protecting this document, you can see that they're shown with • symbols to represent each character in the password.

You can remove the password protection by simply deleting the password or passwords here, then click "OK". (as an experiment, I'm going to remove the password but also check "Read-only recommended".

With that changed, a quick File --> Save As... lets me specify a new name for the non-password-protected (but read-only recommended) file:

Microsoft Excel for Mac OS X: Save As file dialog box

(Tip: a shortcut to set or delete passwords can be found by clicking on the "Options..." button from this file save dialog window too, if you don't want to fiddle with Preferences)

Now when I open up the spreadsheet instead of seeing a password prompt, I see this:

Microsoft Excel for Mac OS X: Open Read Only?

Pretty cool! I hope you can see from my example how to simply remove a password or, for that matter, add password protection to your spreadsheet next time you save it.



Help others find this article at Del.icio.us, Digg, Netscape, Reddit, and Stumble Upon    

Subscribe!

Never miss another useful Q&A article again! Subscribe to AskDaveTaylor with Google Reader.

Comments

i have given a password to one of my excel sheet but i forget it password but in want to open it it is very urgent an you please help it out it is very urgent.

Posted by: preeti at May 8, 2009 1:01 AM

Please Excel Password Remove

Posted by: Muhammad Sultan at February 23, 2010 7:03 AM

A) Open document > Select edit menu > choose select all > then choose copy from edit menu.
Open new document > edit menu> paste.
Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected.
Select save tab>choose and mark box>ask about properties
accept or Apply options and close.
Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.
If this does not work.

B)There are many 3rd party utilities which claim to reset forgotten word password:
The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the "Password to Open" and "Password to Edit" for you to view and edit the document freely.

http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

Posted by: kevin88 at March 8, 2010 1:45 AM

I have something to say, now that you mention it, but ...
Starbucks coffee cup I do have a lot to say, and questions of my own for that matter, but first I'd like to say thank you for all your efforts on this Web site by buying you a cup of coffee!

I do have a comment, now that you mention it!











Remember personal info?


Please note that I will never send you any unsolicited email. Ever.

While I'm at it, please note that by submitting a question or comment you're agreeing to my terms of service, which are: you relinquish any subsequent rights of ownership to your material by submitting it on this site.








Ask Dave Taylor: The iPhone App: Advertisement



Follow me on Twitter @DaveTaylor

Search
Find just the answers you seek from among our 2300+ free tech support articles by using our Lijit search engine.


Help!





Subscribe to
Ask Dave Taylor!

Add to Google Reader
Add to My Yahoo!
Subscribe in NewsGator Online

RDF   XML

Free Updates!
Sign up and get free weekly updates and special offers on books, seminars, workshops and more.


Recent Entries
Book Links
© 2002 - 2010 by Dave Taylor. All Rights Reserved.

Note: This web site is for the purpose of disseminating information for educational purposes, free of charge, for the benefit of all visitors. We take great care to provide quality information. However, we do not guarantee, and accept no legal liability whatsoever arising from or connected to, the accuracy, reliability, currency or completeness of any material contained on this web site or on any linked site.

[whiteboard marker tray]
"Ask Dave Taylor®" is a registered trademark of Intuitive Systems, LLC.