The cell or chart you are trying to change is on a protected sheet
|
Stack Overflow for Teams is moving to its own domain! When the migration is complete, you will access your Teams at stackoverflowteams.com, and they will no longer appear in the left sidebar on stackoverflow.com. Show
Check your email for updates. © CCH Incorporated and its affiliates. All rights reserved.</div> </div> </div> </div> </footer> </div> <div id="ChatAgent" style="display:none"> <div class="chatdiv"> <img class="startChat" src="https://support.cch.com/chat/images/karen.png" width="50" alt="Chat with our virtual representative" title="Chat with virtual representative" id="LucaNew"> <span class="chatText startChat">Chat with our virtual representative</span> <button id="minmizeChat" type="button" class="close" aria-hidden="true" title="Dismiss" style="top:12px;position:relative;right:2px;color:white;opacity:1">×</button> </div> </div> <div id="ChatAgentmin" style="animation:MoveUpDown 1s linear 0s 1 normal none running;width:70px;display:none"> <div class="chatdiv" style="border-radius:36px"> <img src="https://support.cch.com/chat/images/karen.png" width="50" alt="Chat with our virtual representative" title="Chat with virtual representative" id="LucaNew"> </div> </div> <script type="text/javascript"> I use Excel 2016 (that latest version). This never used to happen before. How can I disable this pop-up box from appearing. Please help!! It will surely drive all my data entry staff bonkers too. Thanks, Yusuf 11-17-2017, 03:44 AM #2 Re: "This cell you are trying to change is in a protected sheet..." message for unlocked cyou select "allow users to select unlocked cells" not edit Last edited by sandy666; 11-17-2017 at 03:50 AM.
11-17-2017, 03:54 AM #3
Registered User Re: "This cell you are trying to change is in a protected sheet..." message for unlocked cHi - 11-17-2017, 04:00 AM #4 Re: "This cell you are trying to change is in a protected sheet..." message for unlocked cI don't know what are you doing there 11-19-2017, 06:21 AM #5 Registered User Re: "This cell you are trying to change is in a protected sheet..." message for unlocked cHi - Why is Excel saying it is a protected sheet?By default, Excel activates certain “protected view” settings. This is meant to prevent you from opening an potentially infected file downloaded from the Internet, sent to you in an Email, etc.
Why is my Excel file locked for editing by me?If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn't close properly. Tip: Sometimes a file may get locked if everyone editing isn't using a version that supports co-authoring.
Can you edit a protected Excel sheet?The Excel Spreadsheet is Locked with Password
You will not be able to make changes to the file unless you disable the protection mode. Double-clicking the cell for editing purposes will pop a message “The cell or chart you are trying to change is on a protected sheet. To make a change, unprotect the sheet.”
|
