Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

VBA abilty to refresh a Power Query Group (a.k.a. folder of queries) using a single script line

We need a VBA solution to allow a module/macro to refresh a Power Query Group by name. This solution would allow a single line of VBA code to refrence the Power Quer Group (folder) Name and refresh all queries within that folder.

It could be something as clean as:

ThisWorkbook.Connections.Group("My Folder of Queries").Refresh

34 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Todd shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base