How to replace a data source

I created a Power query from Excel file A which contains personnel details of all employees in my company. I applied several steps to get rid of and rename columns.
I then merged Excel file A with Excel file B which contains the list of thousands of users of an application I'm revising.

Now a more recent version of Excel file A has come out.
I hoped I'd be able to replace file A with the new file when it got updated.
But I can't find a way to do that. Can anyone help?

I'm using Excel 2010.

Hi there. Do you mean you just want to point your query at a different file?

Edit the query. In the "Applied Steps" window on the right, click the gear icon to the right of the Source step. That should let you update the file path.


Sent from my iPhone using Tapatalk