Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel un password cells

31 Dec 2009   #1
steve208

Windows 7 64 bit
 
 
Excel un password cells

Hi
I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks


My System SpecsSystem Spec
.

31 Dec 2009   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit
 
 

Open Excel. Go to the help function (?), and type in password. You will get a lot of information.

I don't know how easy it is to completely remove password protection if you were not the person that developed the worksheet.
My System SpecsSystem Spec
31 Dec 2009   #3
Adrian

 

Quote   Quote: Originally Posted by steve208 View Post
Hi
I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
STeve, unless you authored the worksheet you will not be able to crack the password protect.
My System SpecsSystem Spec
.


31 Dec 2009   #4
steve208

Windows 7 64 bit
 
 

The document was done by one of my mates who can't remember the password to unlock data stored in certain cells, there is alot of stuff in the work sheet so i don't want to start all over again, just realised its not a excel 2007 sheet but a 2003 sheet, don't know if that helps but what i have read 2007 documents are alot better on security.
My System SpecsSystem Spec
31 Dec 2009   #5
Adrian

 

Steve review the information on this link: http://office.microsoft.com/en-us/ex...968371033.aspx
My System SpecsSystem Spec
01 Jan 2010   #6
steve208

Windows 7 64 bit
 
 

Thanks for the help, but the link takes me insrtuctions on how to unprotect a sheet if you know the password which i don't, i can open the sheet but when i click on the unprotect tab under review, it asks for a password this is the one we can't remeber. I'm using excel 2007 (in compatability mode) but with documents made in excel 2003
My System SpecsSystem Spec
01 Jan 2010   #7
ickymay

win7 ultimate / virtual box
 
 

Quote   Quote: Originally Posted by steve208 View Post
Thanks for the help, but the link takes me insrtuctions on how to unprotect a sheet if you know the password which i don't, i can open the sheet but when i click on the unprotect tab under review, it asks for a password this is the one we can't remeber. I'm using excel 2007 (in compatability mode) but with documents made in excel 2003
maybe try this Excel Password Remover 2010
My System SpecsSystem Spec
01 Jan 2010   #8
steve208

Windows 7 64 bit
 
 

Thanks ickymay, i have tried this one, but because im using excel 2007 this program won't load into excel 2007, only works upto 2003 version,(they do a 2007 version at £25), as its an add on to the excel program it gives you more options in the tools menu, because im running excel 2007 i need a program that can intigrate into excel 2007 or a stand alone program.
My System SpecsSystem Spec
02 Jan 2010   #9
ickymay

win7 ultimate / virtual box
 
 

difficult to find a free one for excel 2007 but this one Excel Password Recovery Master says it will allow
Quote:
One license includes the online decryption support for a single "open" password and the unlimited use for other excel passwords
so you may be able to use it for the cell passwords
My System SpecsSystem Spec
03 Jan 2010   #10
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi guys
A bit of a "After the Horse" type of suggestion here - but in future if you need protected data then the BEST way to do this is NOT to use EXCEL passwording but to convert the whole kybosh into a DATABASE application (ACCESS/ MySQL etc etc).

That way you can restrict information based on USER access rights rather than passwords which in a large organisation where people leave, switch assignments etc etc cause more problems than they ostensibly solve.

It's really SIMPLE to convert / import / export stuff from EXCEL / to EXCEL into / from ACCESS databases and MySQL (Free) is also a runner here.

Doesn't solve the immediate problem I know but for "Next time".

BTW a possible work around your problem might be to try and open your spreadsheet with OPEN OFFICE (FREE) -- especially if you can do it on a Linux system -- then the password protection will be just DATA to the linux system.

The latest versions of Open Office are reasonably compatable with EXCEL -- even where macros are used.

http://www.office-3.org/default/inde...eid=1028533860

Cheers
jimbo
My System SpecsSystem Spec
Reply

 Excel un password cells




Thread Tools





Similar help and support threads
Thread Forum
Microsoft Excel Password Recovery
Hey Guys, I'm done some googling and seems there are a bunch of tools that aren't legit for what I need. A user had set a password on an excel sheet and can't get back in. I need a tool that will help me recover the password for the whole file, not just one sheet. If any of you know off hand,...
Microsoft Office
Forgot Excel Password
Can anyone help me? I have a password on excel and I don't even remember setting it but its asking for it. Any chance of removing it please. It has a lot of macros on it. Or at least tell me the software to locate/remove the password, am stuck :( Thanks ;)
Microsoft Office
Format cells in excel 2007
I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the...
Microsoft Office
Excel: How do I make some cells remain the same when pulling it down?
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down. Normally it the adds 1 to every cell address,...
Microsoft Office
How to open password protected Excel?
I have one small problem. I cannot open Excel document. It is password protected. Please let me know if you know how.
Microsoft Office
In Excel 2007 why doesn't locking and protecting cells work?
This is literally driving me nuts. I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 00:02.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App