Question : vba refresh all
Answered by : santosh-pal
I have solved the issue by using the following For Each sht In .Sheets For Each qt In sht.QueryTables qt.Refresh Next qt For Each lo In sht.ListObjects lo.QueryTable.Refresh BackgroundQuery:=False Next lo For Each pvt In sht.PivotTables pvt.PivotCache.Refresh Next pvt Next sht
Source : | Last Update : Tue, 30 Mar 21