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
ActiveWorkbook.Connections("Query - A").Refresh
ActiveWorkbook.Connections("Query - B").Refresh
Shall I remove refreshing A?
note: "A" query is geting data from same workbook table
Bookmarks