Hi gurus,

I have a dropdown list, made with data validation, and I would like that all my pivot tables get automatically updated with the selection of the item.

Currently, I need to hit the refresh button to get them refreshed with the selection. Is there any wayt to automate this?

Many thanks!!!