This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Hello,
I have several Excel Power Queries in my excel sheet and several Pivot Tables on several Tabs which are made from the data that are the result of the several queries.
Now I want to automate everything that after the new variables are selected that everything will be refreshed when i activate the refresh All function.
The queries have a position, the previous has to be completed before the next query may start.
After all the queries are processed each pivot table has to be refreshed.
Is it possible to arrange this in power query by changing options or parameter.
If it is possible we want to make this happen without using a Macro or VBA-script.
If it isn't possible without using a Macro or VBA-script than i want to ask if someone can help/make me a script that refreshed the queries one after the other is completed and then refreshes the pivot tables.
In attachment a print screen of the power Queries in a sheet.
Thank You In Advance.
My Best Regards.
IMHO some clarifications are required... re. The queries have a position, the previous has to be completed before the next query may start
Please explain why as IF the queries you talk about here are those you want to "combine" as one in your other thread this is going to be a none issue, a Refresh All should do what you want after implementing what's been suggested on your other thread
The queries in the previous thread are the first queries in the workfile. After these queries there are still several other queries. For example queries that import data from an oracle database and queries that processes the data and delivers a result like i want.
If it's possible to combine all the queries in one query this could be a solution.
A solution I thought of was to make sure that one query only starts when the other one ends.
Re. If it's possible to combine all the queries in one query this could be a solution
Combining all queries as one isn't necessarily possible, this all depends on your workflow
Also, depending on the workflow a query can reference another that can reference another... In other words you can have 10 queries that at the end produce a single output: a Table, a Pivot Table...
Could you upload & share (i.e with OneDrive) your workbook so one has a chance to understand your workflow (the sequence of your queries)?