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 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
Got it. Thanks alanhodgson!