Hi all,

i have three pivot tables in a sheet, all referring to the same data range. i would like to have a vba code that can help to automatically update the data source range and then refresh all of the pivot tables. Is it possible to do that? if so, how?


Thanks alot in advance everyone!