Results 1 to 3 of 3

Thread: How to add data in Excel when sheet protection is activated

  1. #1
    Join Date
    Dec 2011
    Posts
    59

    How to add data in Excel when sheet protection is activated

    I have a unlocked cell, with Data Validation, List. With sheet protection activated I cannot "add" to the cell contents supplied from the List function. If sheet protection is off, this is possible. Is there a way to have this feature with sheet protection turned on (activated)? If you guys have any of the information or any of the suggestion then please let me know.

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: How to add data in Excel when sheet protection is activated

    Are you saying that in say cell A1 you have a drop down list created via data validation? You’re clicked on this cell and chosen format / cells / protection - and unchecked locked and then when you choose tools / protection / protect sheet you can't make a selection from the drop down list in A1? If so, this is definitely not the standard behavior of excel, so: what version / service packs etc (help / about microsoft excel)? If you test the same scenario in a new workbook what happens? Is there anything odd or unusual about the list (is it create using a range name, or have you typed the entries into the source line in the data /validation dialog box - not that it should make a difference)?

  3. #3
    Join Date
    Jun 2011
    Posts
    798

    Re: How to add data in Excel when sheet protection is activated

    If the sheet is protected, you can't change the cell's Data Validation. So, if you typed the list in the Data Validation dialog box, you won't be able to modify the list. Instead, you could use a dynamic list on an unprotected sheet, and add entries to that list.

Similar Threads

  1. excel spread sheet data transfer help
    By elijah58 in forum Software Development
    Replies: 2
    Last Post: 29-08-2012, 03:54 PM
  2. Replies: 5
    Last Post: 25-02-2012, 10:39 AM
  3. Replies: 2
    Last Post: 23-02-2012, 05:25 PM
  4. Parsing data in Excel Sheet
    By Ossi in forum Windows Software
    Replies: 4
    Last Post: 04-02-2011, 07:25 AM
  5. Identifying common data in an excel sheet
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 25-12-2009, 06:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,638,766,754.44386 seconds with 17 queries