*OOPS* I meant Activeworkbook.RefreshAll for the title
I have a data range source for a pivot table. I apply filters with vba, but the pivot table is hiding all data until it is manually refreshed.
Activeworkbook.RefreshAll does not refresh it while the code is running, ONLY when I step through with F8.
I've tried adding -
Calculate
DoEvents
Application.Wait(Now() + Timevalue("00:00:15"))
Save
Nothing will populate this table, only a manual right click refresh, refresh via data tab or a manual F8 step through over the RefreshAll.
Any ideas?
I have a data range source for a pivot table. I apply filters with vba, but the pivot table is hiding all data until it is manually refreshed.
Activeworkbook.RefreshAll does not refresh it while the code is running, ONLY when I step through with F8.
I've tried adding -
Calculate
DoEvents
Application.Wait(Now() + Timevalue("00:00:15"))
Save
Nothing will populate this table, only a manual right click refresh, refresh via data tab or a manual F8 step through over the RefreshAll.
Any ideas?