Hi Pal,
Recently i have create a pivot from sheet A, and apply data validation list from sheet B into the pivot, when i filter the pivot then i found out my data validation was gone, i need to reset again. It happen every time when i filter and sorting the pivot, may i know does this issue can be solve?
Appreciate and thanks.
Rdgs