Hi all,

I use Power Query to add an excel data file. That file is good for a 3 month cycle. When I clear the data and add in a new data file (new name) then any formulas I have within the workbook that is connected to that data file shift from say A3:H300 to J3:N300. Does anyone know why it does that, and more importantly how can I stop it from happening?