Suresh1980
08-18-2015, 04:44 AM
Hello all,
If someone can help me out for the below issue that would be great.
I created list validation in "Column G", so that by using drop down we can select the name from the list.
All I want is to protect the "Column G", so that no one can manually enter the names other than the drop down list (Right now my team members copy and paste names from other cells. So list validation is getting lost as well as some type "Name A" or "NameA"). So when I try to run a Pivot I get multiple combination of "Name A".14207
If I use "Protect" option, its not allowing me use drop down option as well.
Is there an option to Protect the column and as well drop down can be used.
Regards
Suresh
If someone can help me out for the below issue that would be great.
I created list validation in "Column G", so that by using drop down we can select the name from the list.
All I want is to protect the "Column G", so that no one can manually enter the names other than the drop down list (Right now my team members copy and paste names from other cells. So list validation is getting lost as well as some type "Name A" or "NameA"). So when I try to run a Pivot I get multiple combination of "Name A".14207
If I use "Protect" option, its not allowing me use drop down option as well.
Is there an option to Protect the column and as well drop down can be used.
Regards
Suresh