Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Not able to edit a lock sheet in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 25-01-2012
Member
 
Join Date: Aug 2011
Posts: 539
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
Reply With Quote
  #3  
Old 25-01-2012
Member
 
Join Date: Jul 2011
Posts: 618
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.
Reply With Quote
  #4  
Old 25-01-2012
Member
 
Join Date: Jul 2011
Posts: 632
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Not able to edit a lock sheet in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to get rid of single quote in Microsoft Excel sheet Wisaal MS Office Support 2 10-02-2012 05:22 PM
How to recover a deleted sheet in Microsoft Excel 2007 Al Kaholic MS Office Support 2 24-01-2012 07:44 PM
What is the way to Expand/Collapse Grouped Data in a protected sheet of Microsoft Excel @nkit Trivedi MS Office Support 5 24-01-2012 01:10 PM
How to do Copy/Paste on protected work sheet in Microsoft Excel Chini mao MS Office Support 1 14-01-2012 06:58 PM
How to reconstruct the Microsoft Project Task information to Excel sheet by VBA? goldedit Software Development 1 21-04-2009 12:00 AM


All times are GMT +5.5. The time now is 08:18 AM.