Hi,
I want to refresh a pivot table according to the data present in the next sheet.
I used refresh pivot table activity but the latest record are not captured means the data source is not getting change.
Please suggest I don’t want to use recording and hotkeys as well