Results 1 to 4 of 4

Thread: Not able to edit a lock sheet in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    25

    Not able to edit a lock sheet in Microsoft Excel

    Ok, there's only 2 computers in my office, and I'm the only one here right now. I have an excel file I need to edit, and it says its locked for editing. I turned the other computer completely off. How can I override this.

  2. #2
    Join Date
    Aug 2011
    Posts
    542

    Re: Not able to edit a lock sheet in Microsoft Excel

    Had you been using the other computer to access your file. Did you close it down correctly. Other threads on this subject seem to suggest that re-booting usually does the trick.

    How to unlock word documents

  3. #3
    Join Date
    Jul 2011
    Posts
    627

    Re: Not able to edit a lock sheet in Microsoft Excel

    It all depends on how it is locked. It can be locked by a password or locked by write-protecting sheets. You might not be able to modify the sheet unless you have the unlock password. It is also not easy to unlock the sheet with the help of any tool. Try to find out the exact password for the same and then disable the protection.

  4. #4
    Join Date
    Jul 2011
    Posts
    642

    Re: Not able to edit a lock sheet in Microsoft Excel

    Excel passwords can be removed by by opening the file with Open Office and from there without entering the PW protection. Has worked for me in 99% of cases, although it really should not be the PW's but apparently that are not recognized by Open Office.

Similar Threads

  1. How to get rid of single quote in Microsoft Excel sheet
    By Wisaal in forum MS Office Support
    Replies: 2
    Last Post: 10-02-2012, 04:22 PM
  2. How to recover a deleted sheet in Microsoft Excel 2007
    By Al Kaholic in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 06:44 PM
  3. Replies: 5
    Last Post: 24-01-2012, 12:10 PM
  4. How to do Copy/Paste on protected work sheet in Microsoft Excel
    By Chini mao in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 05:58 PM
  5. Replies: 1
    Last Post: 20-04-2009, 11:00 PM

Posting Permissions

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