Change loading destination from table to connection only

Опубликовано: 13 Сентябрь 2024
на канале: Celia Alves - Solve & Excel

Did you load all the queries to tables in New sheets?
You didn't want any of those new sheets or tables?

Are you annoyed that you will have to change the loading destination to all
the queries one by one and delete all the sheets?

Hold on! There's a quicker way to solve that!

-Hold CTRL while selecting all sheets with query tables that you
do not want to load to tables.
-Now delete the selected sheets.
-Watch the loading destination change to Connection Only.

Learn how to set "connection only" as the default destination for all new queries:

Did you find this tip useful?

Learn how to automate your Excel Reports:

Celia Alves - Microsoft MVP & Certified Excel Expert,
Solutions Developer Solve & Excel Consulting -
LinkedIn:
Facebook: