Problem opening Spreadsheet

Discussion in 'Microsoft Office Specialist (MOS), Office 365' started by Kopite_21, May 28, 2012.

  1. Kopite_21

    Kopite_21 Gigabyte Poster

    1,309
    64
    130
    Hi Guys,

    Was just wondering I have a Spreadsheet that I need to open but I had it password protected. The problem is I have forgot the password and was just wondering if there is another way if I could open the Spreadsheet. I am using Microsoft Office 2003. :rolleyes:

    Regards

    Rob
     
    Certifications: National Diploma IT Advanced ECDL
    WIP: A+
  2. ade1982

    ade1982 Megabyte Poster

    566
    12
    52
    There are loads of dictionary based password-crackers for Excel. Hope you didn't set too good a PW!!
     
  3. Kopite_21

    Kopite_21 Gigabyte Poster

    1,309
    64
    130
    Mixture of Letters & Numbers. Just cannot remember which order now though.
     
    Certifications: National Diploma IT Advanced ECDL
    WIP: A+
  4. SimonV
    Honorary Member

    SimonV Petabyte Poster Gold Member

    6,651
    180
    258
    I did do this once with a basic dictionary based password hacker program I found on the net. No idea what the app was called as it was some time ago now. Luckily the password was a nice simple one to crack so with your being a mixture of letters and numbers you might struggle with one of the free apps to crack it.
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  5. UncleBeard

    UncleBeard Nibble Poster

    72
    3
    31
    I have some VBA code I can send you, found on the net, which has worked for me in the past. Or I can try cracking it open for you using the code if there's nothing too confidential in it. How comfy are you with VBA?

    Found a useful link: http://www.mcgimpsey.com/excel/removepwords.html tells you everything you need to know about Excel passwords :)
     
    Last edited: May 29, 2012
    Certifications: MOS 2003, 2007 and 2010, Master 2003, 2007 and 2010, MMI 2003, MCT, ITIL Foundation
    The Zig likes this.
  6. Kopite_21

    Kopite_21 Gigabyte Poster

    1,309
    64
    130
    I used VBA sometime ago. But I will have a look at the link you just sent me, so when I finish work I'll have a go and see what happens. It's just a spreadsheet of personal finances & tax.

    Thank You for your help

    Regards

    Rob.
     
    Certifications: National Diploma IT Advanced ECDL
    WIP: A+
  7. The Zig

    The Zig Kilobyte Poster

    305
    19
    46
    Informative link there.
    Hope Kopite can get his data back.

    I forgot a password for TrueCrypt once. That is NOT so easy to work around.
     
    Last edited: May 29, 2012
    Certifications: A+; Network+; Security+, CTT+; MCDST; 4 x MTA (Networking, OS, Security & Server); MCITP - Enterprise Desktop Support; MCITP - Enterprise Desktop Administrator; MCITP - Server Administrator; MCSA - Server 2008; MCT; IOSH; CCENT
    WIP: CCNA; Server 2012; LPIC; JNCIA?
  8. SimonD
    Honorary Member

    SimonD Terabyte Poster

    3,681
    440
    199
    It depends on the version of Excel used to create the document, I have had older documents open in minutes whilst others have indicated months to crack (and that was using a very hefty box).

    Have a look at Password Recovery | Passware for their kit, generally pretty good.
     
    Certifications: CNA | CNE | CCNA | MCP | MCP+I | MCSE NT4 | MCSA 2003 | Security+ | MCSA:S 2003 | MCSE:S 2003 | MCTS:SCCM 2007 | MCTS:Win 7 | MCITP:EDA7 | MCITP:SA | MCITP:EA | MCTS:Hyper-V | VCP 4 | ITIL v3 Foundation | VCP 5 DCV | VCP 5 Cloud | VCP6 NV | VCP6 DCV | VCAP 5.5 DCA
  9. Kopite_21

    Kopite_21 Gigabyte Poster

    1,309
    64
    130
    Hi guys,

    Just to let you know I have solved the problem with my Spreadsheet.

    The password just came to me yesterday so now I can use it again, but I would like to say thanks to you who sent suggestions.

    Regards

    Rob :D
     
    Certifications: National Diploma IT Advanced ECDL
    WIP: A+

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.