Hi,

I have created a connection using Power Query to a worksheet which is used to populate a pivot table.

Each month I will paste over the data in the worksheet and refresh connection to update the pivot table.

One problem is that the heading in one of columns in the worksheet changes each month to show the date of the latest month-end (formatted as text).

This causes the query to fail when I try to refresh it.

Is there a way around this other than manually to adjust the column header in the worksheet to be something that doesn't change each month?

Thanks!