Refreshing only connection query

[Undo]

Hello

only connection query can't be refreshed so that mean its always updated?
mean if "A" table is only connection query
and query "B","C","D" (loaded in worksheet query) Taking data between them and "A" table
anytime I refresh "B", the "A" will be ready and always updated?
I am refreshing queres manully by VBA and evrytime I refresh A before others like this

Please Login or Register  to view this content.

Shall I remove refreshing A?

note: "A" query is geting data from same workbook table

[romperstomper]

Any queries that use a connection only query will run it when they are refreshed.

[Undo]

So shall I remove updating "A"? note that "B" query is loaded in worksheet and read from "A"

[Undo]

After few testing I see that I dont need to update all tables in the query tree to update the final table, I can update the final table alone
like I update table3 only and I got the updated data
table3 geting data from table2 query, and table2 query get data from table1 query
1.jpg