hi
till now i was using Marcel Beug's method of queriying my own query to add additional columns. it worked maginificiently
however, this created a workbook with over 30 worksheets as each query is using a predecessor and each query needs to be refreshed multiple times for all the queries to update (refresh all needs a few runs)
refresh all is also very slow
i just learned that i could create connection only queries and then reference them in a merge
if i redo all my queries, will it make refresh all go faster
is the effore worthit
basically my question is which is better practice and more efficient for the running of the workkbook
1- may worksheets and loaded queries
-vs many connection only merged and then the outputs as loaded sheets
till now i was using Marcel Beug's method of queriying my own query to add additional columns. it worked maginificiently
however, this created a workbook with over 30 worksheets as each query is using a predecessor and each query needs to be refreshed multiple times for all the queries to update (refresh all needs a few runs)
refresh all is also very slow
i just learned that i could create connection only queries and then reference them in a merge
if i redo all my queries, will it make refresh all go faster
is the effore worthit
basically my question is which is better practice and more efficient for the running of the workkbook
1- may worksheets and loaded queries
-vs many connection only merged and then the outputs as loaded sheets
