Data validation only works once

  • Thread starter Thread starter Dale G
  • Start date Start date
D

Dale G

Hi, I created a data validation drop down from a list & when I select a name
in the drop down it will place the selected name in the cell just as it
should.
When I move to or select a different cell on the same worksheet & go back to
the drop down the drop down is no longer there. ??

Has anyone heard of this happening?
 
Nevermind, I had the dropdown between 2 pivot tables so I can select a name
and have both PTs show the data according to my selection.

I moved the dropdown one line above the 2 PTs and now it works fine.
 
Back
Top