Power Query Error

[thewiseguy]

I can't seem to figure out if there is a way to use the MrExcel add-in to get a snapshot of the power query issue I am having, so I will try to explain.

I went to the source file and added a column to my data. This column was 3rd from the left and when I went to my active worksheet and refreshed the data, i am getting an error that says:

"Expression. Error The column 'MaskedPartNumber" of the table wasn't found (MaskedPartNumber is my first column.

Any ideas on how to fix this??

 

[alansidman]

Make sure that there are no leading or trailing spaces and that spelling is exactly the same including capitalization. Also, can you show us your Mcode so that we can look and see if there is anything that stands out