Copy Power Query to new sheet, change file location

llarsen

New Member
Joined
Jul 29, 2014
Messages
5
I've created a query on sheet "2018" that pulls from 4 docs in a "2018" folder on my server. I then created a "2019" sheet by copy/move and created a "2019" folder on my server and tried to change the query source of the data in the 2019 sheet but it changed the source of the 2018 query as well. Is there a way to change the source for the 2019 sheet but not for the 2018 sheet?

thanks,
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
At the moment in your workbook you have one query linked to 2 tables, one table is residing on 2018 sheet and one table is residing on 2019 tab. You need to create a second query where you will update the data source and then have the query paste the data on the 2019 sheet after having deleted the table that now is on the 2019 tab
 
Upvote 0
Did you try "Advanced editor" and manually change the address,
or the little wheel in the powerquery first step (source), and changed the address for the new excel file that should work on 2019 folder?
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top