Excel Power Query Moves old Data to the right

Question

I'm now putting data from one file into a workbook's data tab. Power query would help me move things along more quickly. My old data is pushed to the right and any cell references go with it when I drag data from a file into a spreadsheet.

Is it possible to replace what already exists? I realise that once it is initially set up as a power query function, there won't be any issues; all I have to do is reload the worksheet.

Answer 1

Just empty the page and then add the data, The cell references do not change as there is no data to push to the right.