Help I've locked my Excel spreadsheet!

Discussion in 'General Chat' started by mikeclark007, Jun 23, 2015.

  1. mikeclark007

    mikeclark007
    Well-known Member

    Joined:
    Oct 16, 2007
    Messages:
    3,610
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    106
    Location:
    Scarborough, North Yorkshire
    Ratings:
    +271
    Don't know how I've done it but I've managed to lock a tab from my excel workbook for editing as I can't remember the password. I thought it was the same password for the whole workbook but it's not.

    Is there a workaround?

    Thanks
    Mike
     
  2. Sniper Ash6

    Sniper Ash6
    Distinguished Member

    Joined:
    Jun 5, 2008
    Messages:
    27,876
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    127.0.0.1
    Ratings:
    +7,695
    Is it something you'd be able to send over? It can be possible to remove the protection without having to brute force the password.
     
  3. mikeclark007

    mikeclark007
    Well-known Member

    Joined:
    Oct 16, 2007
    Messages:
    3,610
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    106
    Location:
    Scarborough, North Yorkshire
    Ratings:
    +271
    Thanks for the offer mate. Yes would have been able to send it over - nothing sensitive but I've managed to unlock it. It's a mix of upper / lower case and when I set the password I got them he wrong way round
     
  4. andyparksy

    andyparksy
    Well-known Member

    Joined:
    Dec 9, 2009
    Messages:
    1,325
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    116
    Location:
    London
    Ratings:
    +543
    For info, there are quite a few add-ons around that can break excel passwords. Some try to get you to pay for them, and others might be from a dubious source as it provides a way to introduce macros, so be careful, but there is a famous one from a chap called John Mote - I have been using it for about 10 years and is incredibly useful (and shows how ridiculously insecure excel security is).

    His one is an automated brute force method that cannot tell you the password, but does remove it from both workbooks and / or sheets.
     
  5. SteakAndCake

    SteakAndCake
    Distinguished Member

    Joined:
    Nov 22, 2012
    Messages:
    7,161
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Ratings:
    +7,456
    Have you tried 1234?
     
  6. hippo99

    hippo99
    Distinguished Member

    Joined:
    Feb 29, 2008
    Messages:
    17,153
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    163
    Ratings:
    +10,284
    Too simple.
    It was either:
    a) Jesus
    b) sex
    c) money
     
  7. technoman28

    technoman28
    Well-known Member

    Joined:
    Sep 7, 2004
    Messages:
    1,435
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    86
    Location:
    Newcastle upon Tyne
    Ratings:
    +451
    I believe you can unlock documents in "open office", I did it once and it was simple and quick.
     
  8. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    Presumably this is more a problem with weak passwords than Excel in particular (assuming this software just tries lots of passwords)
     
  9. andyparksy

    andyparksy
    Well-known Member

    Joined:
    Dec 9, 2009
    Messages:
    1,325
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    116
    Location:
    London
    Ratings:
    +543
    No, excel itself is very unsecure. All of these tools can get into the spreadsheets very quickly (about 2 minutes), no matter what the password is..... Random numbers get removed the same as "password" in brute force methods (they just quickly cycle through combinations, not actual words). If everyone realised how easy they are to remove for people that tried to, nobody would even bother with them. (but, usefully, they don't)
     
  10. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    Interesting - reading up on it, pre version 2013 (!) the password was stored as a poor many-to-one hash with only few combinations. 2013 and on it's stored with a much more decent hash and is salted, so I would be surprised if these tools continued to work on them if the password is decent.
     
  11. Sniper Ash6

    Sniper Ash6
    Distinguished Member

    Joined:
    Jun 5, 2008
    Messages:
    27,876
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    127.0.0.1
    Ratings:
    +7,695
    Glad you got it sorted

    You can still just delete the element telling it that it's protected...
    Excel.png
     
  12. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    Interesting - so you can take a file like this and pull out the movie title in it for example?
     
  13. Sniper Ash6

    Sniper Ash6
    Distinguished Member

    Joined:
    Jun 5, 2008
    Messages:
    27,876
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    127.0.0.1
    Ratings:
    +7,695
    No, but that's because of Dropbox giving a 404 :p
     
  14. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    Try now, as they say :)
     
  15. sophies hero

    sophies hero
    Active Member

    Joined:
    May 5, 2011
    Messages:
    1,530
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    66
    Location:
    coventry
    Ratings:
    +222
    Any excel wizards out there that could help a stranger out? I'm a plasterer so excel really really isn't my forte. I've been given one to use for booking my work in but i can't help feel it can be improved.... Fee's negotiable.
     
  16. sophies hero

    sophies hero
    Active Member

    Joined:
    May 5, 2011
    Messages:
    1,530
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    66
    Location:
    coventry
    Ratings:
    +222
    Or are there excel people u can use for one off's? Really clueless on this
     
  17. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    What is the actual scope of the changes you are looking for?
     
  18. sophies hero

    sophies hero
    Active Member

    Joined:
    May 5, 2011
    Messages:
    1,530
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    66
    Location:
    coventry
    Ratings:
    +222
    ImageUploadedByTapatalk1435094907.608006.jpg

    I type in wall length and wall height, it then does the simple calculation for m2 which i have to retype in the skim column for it to add it to the total. Could it not automatically copy the m2 measurement to that box? Also in the bit that says fire tape i have to retype the length...could it be changed that if i type Y in the fire tape box it copies the length measurement over? Does that make sense?
     
  19. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    If you put

    =G7

    into cell K7, for example, it will take the value from there automatically. (G being the m2 column, and K being the Skim column). You would then need to repeat this exercise for each row, which you can do by dragging down the square at the bottom right of the cell K7 when you select it.

    If you just want to copy the value every time, you can do the same as the above for columns J and E.

    If you want to do it 'conditionally' - i.e. sometimes and sometimes not, you would probably need to add a column which you could put the Y or N in. Depends on the underlying formulas going on.

    HTH
     
  20. sophies hero

    sophies hero
    Active Member

    Joined:
    May 5, 2011
    Messages:
    1,530
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    66
    Location:
    coventry
    Ratings:
    +222
    Ok thanks. = g7 will probably help me out even if its not quite what i had in my head. I do it on my phone throughout the day and it'll be easier to type that than to keep scrolling side to side to see each measurement. Thanks [emoji106]
     
  21. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    No problem. Good luck :)
     
  22. Sniper Ash6

    Sniper Ash6
    Distinguished Member

    Joined:
    Jun 5, 2008
    Messages:
    27,876
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    127.0.0.1
    Ratings:
    +7,695
    That's changing the game but spreadsheet encryption is, I believe, done properly (a completely encrypted file, hashed and salted) whereas worksheet protection is weak because at its most basic it's almost read only.

    All sounds doable to improve and make easier. We're happy to help if you can put down what you need (in terms of rules) and send over a mocked up sample.
     
  23. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    :D Alls I did was save the spreadsheet and pick a password - isn't that what we're talking about? :) 'Worksheet protection' doesn't prevent you opening the file without a password, right? Just prevents you from modifying it.
     
  24. sophies hero

    sophies hero
    Active Member

    Joined:
    May 5, 2011
    Messages:
    1,530
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    66
    Location:
    coventry
    Ratings:
    +222
    Thanks that'd be kind, i'll fill one out showing what i'd like it to do, is that what you mean?
     
  25. andyparksy

    andyparksy
    Well-known Member

    Joined:
    Dec 9, 2009
    Messages:
    1,325
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    116
    Location:
    London
    Ratings:
    +543
    Not quite........ As Ash said there is a difference when you put a password to open the file - this actually encrypts the file and does stop it being opened. I was more talking about being putting passwords in excel to change the workbook or sheet once it has opened (things like unhiding hidden sheets, allowing you to select all cells, editing). It means you can see things that people think were hidden.

    I guess the difference is the situation in which you are given a spreadsheet but the author only wanted you to see some bits of it (but now you can see all of it), as opposed to opening something on a server when you shouldn't be looking at any of it........
     
  26. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,356
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,532
    Okay right - was really trying to clarify the point about excel being 'very unsecure'. You can definitely lock users out if you want to. ' Protecting' elements is more like asking them not to mess with it.
     

Share This Page

Loading...