pivot table won't refresh

[hh2020]

Hi,

I have the macro file to copy some data from one sheet to another sheet from pivot table. I have the refresh button for users to click on it to refresh the latest data instead of go to data and refresh. Everything works as expected for me, but it didn't get refresh from the user? I am thinking about the cache or what?

Thanks

[6StringJazzer]

We cannot answer this question without seeing your code, at a bare minimum. You will get the best answers if you attach your file (see yellow banner at the top of the page).