G
Guest
Hi
My pivot table dropdowns keep data whether it is still valid or not.
I am expecting it to behave like a filter dropdown which refreshes each time
you use it.
Is there some way of refreshing the data ???
My list is now 3 times bigger than it need to be the only way I can get rid
of the old entries is to delete the pivot and re-create it - which is time
consuming...
Any suggestions would be warmly welcomed...
My pivot table dropdowns keep data whether it is still valid or not.
I am expecting it to behave like a filter dropdown which refreshes each time
you use it.
Is there some way of refreshing the data ???
My list is now 3 times bigger than it need to be the only way I can get rid
of the old entries is to delete the pivot and re-create it - which is time
consuming...
Any suggestions would be warmly welcomed...