Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2007
    Location
    Beverly, USA
    Posts
    99
    Thanks
    0
    Thanked 1 Time in 1 Post

    removing protection from an Excel spreadsheet

    My boss has an excel spreadsheet that was probably generated in Excel 2003 (now being edited in Excel 2010) and he can't figure out how to remove the password to allow editing. (He can't let me try and work on the file because it's confidential).

    All the blog posts and support forum posts I have found suggest that he should be able to got to the review tab and select un-protect worksheet to remove the password, but there's not un-protect workbook option.

    Any ideas on where else the permissions might be hidden?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,056
    Thanks
    196
    Thanked 760 Times in 695 Posts
    Chris,

    When the workbook is opened does it prompt for a password?
    And if so is he entering the Modify Password vs the Open R/O password?
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #3
    Star Lounger
    Join Date
    Oct 2007
    Location
    Beverly, USA
    Posts
    99
    Thanks
    0
    Thanked 1 Time in 1 Post
    We've killed the "Open" password. Now we're looking to get rid of the "Modify" password.

  5. #4
    4 Star Lounger
    Join Date
    Jan 2004
    Location
    Ulaan Baatar
    Posts
    515
    Thanks
    1
    Thanked 42 Times in 40 Posts
    Open the Workbook using both passwords, then:

    File
    Save As
    Tools
    General Options

    . . . then clear both the boxes: "Password to open:" and "Password to modify:"

    That should do it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •