Browse Forum Recent Topics  
 

Welcome to the DeskDemon Forums
You will need to Login in or Register to post a message. To start viewing messages, select the forum that you want to visit from the selection below.

Pages: [1]   Go Down
  Print  
Author Topic: Password Protected Excel Document  (Read 14893 times)
ricki
Newbie
*
Posts: 1



View Profile
« on: October 22, 2009, 05:17:13 am »

I have an excel doc that I need to edit and it says it is password protected!   I can't open it.   The document was last edited by an employee who is no longer with the company so I can't go ask what it was.  Does anyone know how to get around password or am I (how do I say this nicely...) in deep trouble?  This is a really important document.  Anyone have any suggestions?
Logged
gee4
Hero Member
*****
Posts: 5689



View Profile
« Reply #1 on: October 22, 2009, 08:06:00 am »

I am sure someone in your IT department could help override the password in order to access the document.

It's a pity when people move on and passwords aren't communicated.  Lessons to be learned.
Logged
Cathy S
Hero Member
*****
Posts: 638



View Profile
« Reply #2 on: October 22, 2009, 10:39:21 am »

Hi Ricki

My understanding is that the Excel and Word passwords cannot be overridden ... unlike network passwords which can be changed the document passwords are not stored anywhere other than the document and so are not accessible to override.

Sorry that isn't what you want to hear ...

Cathy

Logged
cmeknit
Full Member
***
Posts: 115



View Profile
« Reply #3 on: October 22, 2009, 02:45:24 pm »

Checking out the Microsoft Discussion Groups (http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx) led me to this website -  http://www.mcgimpsey.com/excel/removepwords.html - which claims this macro can remove Excel passwords.  I've never used it, but it's referenced by several of the folks responding to inquiries like yours, so it might be worth a try. 

At the very least, you can select all (Control A), copy (Control C, and paste (Control V) into a new worksheet.  I've used that technique and had good results.

Hope that helps,
Chris
Logged
msmarieh
Global Moderator
Hero Member
*****
Posts: 2768



View Profile
« Reply #4 on: October 22, 2009, 03:33:06 pm »

That depends on if it is password protected to open or to read.

You might also try opening it in an older version of Excel. Sometimes that works. Smiley

There certainly are softwares out there that will crack the software passwords (including the one referenced above). I would work with your IT department on it.
Logged
gee4
Hero Member
*****
Posts: 5689



View Profile
« Reply #5 on: February 11, 2010, 08:53:59 am »

Ahhhhh!  The same thing has happened to me this morning, only they are my documents and I have the password!
Logged
gee4
Hero Member
*****
Posts: 5689



View Profile
« Reply #6 on: February 11, 2010, 09:08:07 am »

(still cannot edit postings)...

Just for info, the 2 excel docs are password protected from the outset.  They are personal to me and I have the password.  The error message I get says, it is already opened by another user or you need permission to view its data.

Would IT be able to help -  the docs were created by me and I use them every day.

Any ideas?  I have already rebooted my pc.
Logged
gee4
Hero Member
*****
Posts: 5689



View Profile
« Reply #7 on: February 11, 2010, 09:16:45 am »

Have managed to open one, by just fiddling, removed password and saved it.

Weird!
Logged
msmarieh
Global Moderator
Hero Member
*****
Posts: 2768



View Profile
« Reply #8 on: February 11, 2010, 04:41:30 pm »

Normally something like that would happen where Excel crashed while you were closing it. You might doublecheck to see if there are any remnant temporary files hanging around out there.

Marie
Logged
gee4
Hero Member
*****
Posts: 5689



View Profile
« Reply #9 on: February 11, 2010, 04:55:38 pm »

I don't know what happened but managed to retrieve both files.  Sometimes I think we make a big deal about password protecting documents, especially when this can happen.

Logged
Cozwaz
Hero Member
*****
Posts: 512



View Profile
« Reply #10 on: February 17, 2010, 09:45:21 am »

I have had exactly the same problem and just used the McGimpsey link and it has worked - thank you so much.

Coz Smiley
Logged
Johny
Newbie
*
Posts: 1


View Profile
« Reply #11 on: April 28, 2016, 05:55:49 am »

Download XLSX file password recovery solution to remove Excel file password and recover Excel file password without any problem. All consumers can successfully break Excel file password and recover XLSX file password, word file password, access file password directly.

Read More
http://www.excelpasswordcracker.n.nu/

Logged

You will need to Login in or Register to post a message.

Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC