Data validation only works once
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.
"Dale G" wrote:
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?
|