Pivot Refresh after External Data Refresh

[happyhungarian]

Hi, I'm using the following code to refresh a web query. My problem is that i have a pivot-table that's sourced from the web query results. I thought the code would refresh both the query and the pivot but I think it's refreshing the pivot before the web query is finished. Is there a way to have the pivot-table refresh to only occur after the web-query is complete?

Private Sub Worksheet_Change(ByVal Target As Range)


If Intersect(Target, Range("C3")) Is Nothing Then Exit Sub


Application.CutCopyMode = False
ActiveWorkbook.RefreshAll


End Sub

 

[happyhungarian]

Is there no answer to this?

 

[happyhungarian]

Solved it. Added a "DoEvents" after the RefreshAll then added a separate line after the DoEvents to refresh the Pivot