Ms Office: Excel Question

Discussion in 'Windows Desktop Systems' started by homesick1337, Feb 5, 2007.

  1. homesick1337

    homesick1337 Computer Lover

    Messages:
    129
    Location:
    Honolulu, Hawaii
    I currently run MS OFFICE 2003. An employee of mine recently quit and password protected many of his old documents that he did for us. I never was able to retrieve the password before he quit.

    Is there a way to unlock these documents? I keep trying to edit all the excel sheets hes done and it says I need a password.

    I even tried to copy paste them into a new document and that won't work either.

    I am really left in a dilema here.
    How can I get around this?


    If anyone can help I would be in your debt.

    Thank You,
    Mathew
     
  2. Sexo um Pato

    Sexo um Pato qvack qvack qvack

    Messages:
    40
    Location:
    SYDNEY
    most of the time I am able to save a copy of the passworded document...click on the save item and it should say "this document is read only" etc... and you can save an unpassworded copy

    the only security options i've really ever used in excel were "password to open" and "password to modify"

    in both cases i can copy and paste data to other spreadsheets...so it sounds like your colleage has done something a bit fancier with his security options.

    Have you considered trying to call your colleage?
     
  3. homesick1337

    homesick1337 Computer Lover

    Messages:
    129
    Location:
    Honolulu, Hawaii
    Yea the password error I get in excel tells me

    "The cell or chart you are trying to modify is protected and there for read only. To modify a protected cell or chart, first remove protection using the unprotected sheet command. Tools, menu, protection menu. You may be prompt for a password".

    I tried to copy and paste , it let me save as also but the copy still gives me that message.

    I would try to call but the person, left without any contact info. This work was also given to me recently without my knowing of how long they have had this and finally decided they needed to use some old excel information for newer company price list.

    Thanks,
    Mathew

    P.S If possible I could email you a copy or sample and maybe you could get a better idea, and see if I am mistaken or not seeing something.
     
  4. Sexo um Pato

    Sexo um Pato qvack qvack qvack

    Messages:
    40
    Location:
    SYDNEY
    yeah - for sure.

    go for it, i'll see what i can do for you.
     
    Last edited: Nov 24, 2009