Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: In Excel 2007 why doesn't locking and protecting cells work?


18 Mar 2011   #1

Windows Vista HP 64-bit, Windows 7 P 64-bit, Leopard 10.5.8, Windows 7 P 32-bit
 
 
In Excel 2007 why doesn't locking and protecting cells work?

This is literally driving me nuts. I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect worksheet" and after checking the box that allows people to select cells in the locked section (selection of sells in unlocked section checks automatically) I enter a password twice and the worksheet is theoretically locked.

The problem is that it's not. I can still change cells in the locked area. It didn't work on any of my worksheets. So I went back and unprotected the sheets and then selected and locked the cells TWICE, after which I protected the worksheets again. This time some, but not all, of the worksheets had locked the cells protecting them from editing. I then tried to go thru the same rigmarole but locking the cells three or four times before protecting the sheets for the sheets that were still unlocked, but that only worked sporadically as well. Sometimes I had to dis-allow selection, lock the cells in the sheet, unprotect it, lock the cells again twice, and then check the select box and protect the sheet AGAIN. That FINALLY worked.

What the heck is going on? Why doesn't locking the cells just lock them? This is getting *very* frustrating.

Note: On one of the sheets even the above rigmarole didn't work. I can't get the cells to lock no matter what I do. What's wrong???

My System SpecsSystem Spec
.

20 Mar 2011   #2

Windows 7 Home Premium 64bit
 
 

.
Here is a 'check list' for protecting your workbook :
Password protect worksheet or workbook elements - Excel - Microsoft Office

Just in case there are any errors, you could try the Diagnostics Tool :
Diagnose and repair crashing Office programs by using Office Diagnostics - Excel - Microsoft Office
My System SpecsSystem Spec
04 Apr 2011   #3

64
 
 
Allow Users to Edit Ranges

Hey Irene,

i had a similar issue. After some trial and error i found out that the solution is hidden on the "Review" tab in the "Changes" ribbon. There is a button called "Allow Users to Edit Ranges". You need to make sure that the cells that you want to protect are not specified as a range here, otherwise users will still be able to edit them even after you have protected the sheet.

That solved it for me. Good luck.

-Julia
My System SpecsSystem Spec
.


04 Apr 2011   #4

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by JuliaHae View Post
Hey Irene,

i had a similar issue. After some trial and error i found out that the solution is hidden on the "Review" tab in the "Changes" ribbon. There is a button called "Allow Users to Edit Ranges". You need to make sure that the cells that you want to protect are not specified as a range here, otherwise users will still be able to edit them even after you have protected the sheet.

That solved it for me. Good luck.

-Julia
Hi Julia, welcome to the forum.

Many thanks for your contribution.
My System SpecsSystem Spec
Reply

 In Excel 2007 why doesn't locking and protecting cells work?




Thread Tools



Similar help and support threads for2: In Excel 2007 why doesn't locking and protecting cells work?
Thread Forum
Excel: How do I make some cells remain the same when pulling it down? Microsoft Office
Locking certain cells from updating Microsoft Office
Autocorrect Outlook 2007 doesn't work in Window 7 properly Microsoft Office
Quickly fill blank cells in Excel. Microsoft Office
Excel 2007 doesn't work properly with windows 7 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel un password cells Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:48 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33