2 years ago

#67985

test-img

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

Accepted video resources