2 years ago
#67985
BlingGirl
How to add multiple Dynamic Power Queries into one spreadsheet excel
Is it possible to insert multiple dynamic power queries, one on top of the other, into a single excel spreadsheet and have the queries refresh when new data has been added to the tables?
I have six different dynamic power queries from six different tables.
When I put each query into their own spreadsheet by themselves they work perfectly. When I add additional data to the table and refresh the query the new data is added to the query worksheet.
However, when I place all six queries into one worksheet one on top of the other, the new data added to the tables will not refresh.
Any help would be greatly appreciated.
Using Excel 365 on Windows 10
excel
refresh
powerquery
0 Answers
Your Answer