Macro not working

[nattiej101]

Good morning - My macro isn't working and I need some help.  I reached out here a bit ago and someone created this macro to help updates/made this format a bit more PowerBI friendly.

I have my original report in the OR Report Scrubbed 2019-2024 file, then I head to the 2016-2023 OR Data.PowerBI format file and update the link in the PARAM tab, and then refresh the table.

I was wondering if you could help fix this macro/table so it will refresh with the most recent data!

This is the error that I'm getting:

[#2]

The error you are seeing isn't caused by any macro. You should open the queries task-pane and check the ones that yield an error. Also, check the last worksheet, see if the filenames are correct.

[#3]

I'm still getting the error - but I looked at the file and the "Planned OR%" is in both files: 

This is where the error is with the Query - but I'm not sure where this "Column1" is coming from.

[#4]

IN the query editor, on the right, there is a list of steps. From the last step keep clicking a previous step until you find a step without that error. Then click the first step that has the error and remove "Column1" from the formula.