Need VBA to refresh all pivot extent data range

[julielara]

Dear experts

i have data with pivot tables i want refresh and extend data source as per data range.

i have 5 pivot in seperate sheet..source of FO_DT link to data range in dashboard

find the attachment

[1aaaaaaaaaaaaaaa]

Hi there, try something like this? Please click "Add Reputation" if I've helped you. Thank you.

Please Login or Register  to view this content.

[julielara]

Thanks expert thanks for your valuable time spend on me solved!! just one question what to do if pivot overlap on another pivot table