Fix a header change

Hi,
Ready to kill this piece of software...

So I created a connection between three tables, then I appended them and created the pivot table I was looking for. All good.
Then I realized I'd typo'd one of the headers in one of the tables. I fixed it and it broke everything.
So I killed the old connection, killed the old append and then created a new connection and a new append and rebuilt the pivot table from scratch, however the error is still there. I get [Expression.Error] the column (typo'd name) of the table wasn't found.
Is there a way to fix this? Is there a better way to make a header change on a table so it doesn't kill the pivot table?

Thanks for any advice!

Thanks for getting back to me!
I can't even FIND the advanced editor!!!
I killed the rest of the connections as well as the one with the typo and started from scratch. I was able to get the thing to work after rebuilding everything, although I lost some utility along the way that I can't figure out how to get back (won't refresh pivot table data unless I do a save first).
The problem with the caption solution is that the error isn't on the pivot table side, I need the table that I've got people inputting data into to read correctly. The column in question isn't even part of the final pivot table!
Thanks again.

got it! Thank you!