|
| ||||||||||
| Tags: microsoft excel, microsoft office, office application, protected sheet, spreadsheet |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| |||
| |||
| Not able to edit a lock sheet in Microsoft Excel
|
|
#2
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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. |
![]() |
|
| Thread Tools | Search this Thread |
| |
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 04:22 PM |
| How to recover a deleted sheet in Microsoft Excel 2007 | Al Kaholic | MS Office Support | 2 | 24-01-2012 06: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 12:10 PM |
| How to do Copy/Paste on protected work sheet in Microsoft Excel | Chini mao | MS Office Support | 1 | 14-01-2012 05:58 PM |
| How to reconstruct the Microsoft Project Task information to Excel sheet by VBA? | goldedit | Software Development | 1 | 20-04-2009 11:00 PM |