Forum Discussion
Shape Multiple Queries at once
I just tested this and it worked fine for me:
1. Navigate to the "Edit Queries" section (same drop down as "data source settings") and open the Query Editor window.
2. You should see Source and Navigation in right pane. Under the Source step, it should look something like this (a table with the workbook information), see below:
3. In the Navigation step, you can change the values to the new worksheet like below:
4. Close & Apply the steps.
Hope this helps,
Alan
I tried duplicating queries and changing sources (or navigation in my case). It works but is incredibly slow if the tables are large, and since I have a lot to work with it would take a very long time. I also had shapes already using the queries that would be replaced (deleted), so having to re-create all of them would have been a major hassle.
After looking around a bit I stumbled across the Advanced Query Editor, which can apply all the steps at once on each query. In the Query Editor (right click on the Field and select Edit Query), go to the View tab, and select Advanced Editor. It will list out the code used in all steps, in order. Simply copy all the steps you want to duplicate (not the source or navigation) and paste them into the queries you want them to apply to. Keep in mind any steps that refer to the original Source/Navigation have to be edited to reflect the query you are currently editing.
In this way you can apply all the steps to each query without having to duplicate them and replace the originals (thereby breaking any shapes using them). And there is only a single wait time as all the steps are applied, rather than waiting at the end of each step as they are calculated.