1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem opening Spreadsheet

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

  1. Kopite_21

    Kopite_21 Gigabyte Poster Premium Member

    1,173
    17
    105
    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 Forum Leader

    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 Premium Member

    1,173
    17
    105
    Mixture of Letters & Numbers. Just cannot remember which order now though.
     
    Certifications: National Diploma IT Advanced ECDL
    WIP: A+
  4. SimonV

    SimonV Petabyte Poster Administrator

    6,616
    151
    228
    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
    WIP: Maybe some MOS 2013 just for the sake of it!
    The Zig likes this.
  6. Kopite_21

    Kopite_21 Gigabyte Poster Premium Member

    1,173
    17
    105
    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 Forum Leader

    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

    SimonD Terabyte Poster Moderator

    3,463
    397
    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
    WIP: VCP6-CMA, VCAP-DCD and Linux + (and possibly VCIX-NV).
  9. Kopite_21

    Kopite_21 Gigabyte Poster Premium Member

    1,173
    17
    105
    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...