CODEWITHSUNDEEP
excelvbarefreshpowerqueryonchange
Michael C
Michael C

Reputation: 59

Refresh query table when cell changes

I've build a number of tables using Power Query. For table "TemplateDataQry", I have a parameter value in cell "G2". The table resides on sheet "TemplateData"

What code is needed to automatically refresh the query when the the parameter cell changes? i have not located anything yet that would work.

Upvotes: 0

Views: 1273

Answers (1)

Michael C
Michael C

Reputation: 59

I found using the Worksheet Event pointing at the the parameter cell was the easiest way to handle it.

Upvotes: 2

Related Questions