-
PowerQuery refresh / Pivot Table refresh
I'm having a problem where my VBA code refreshes my PowerQuery query and then refreshes the pivot table that uses the query results.
Problem is the vba code does not wait until the PQ refresh is complete. So my pivot table refreshes before the new data is available.
Is there a solution to this other than Application.Wait ? The Enable Background refresh is unchecked but that makes no difference.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules