happyhungarian
Active Member
- Joined
- Jul 19, 2011
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
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
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