Data validation only works once

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?
 
D

Dale G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top