Adding new Source Column in Power Query Editor (Excel 2016)

[dogofwar]

I have a spreadsheet that is basically a trimmed down version of my master that gets distributed. To trim it down, I have removed columns and implemented conditional formatting for readability.
Needless to say, very complicated (mostly due to the conditional formatting giving the reader pretty colors) and not something I want to re-create.
Fast forward to today, I've had to add a column to my master and need to show that new column on the trimmed down one. How can I do this without recreating the trimmed down spreadsheet from scratch??
Oh, and we only have Excel 2016

TLDR: Need to update a query to include a new column from the source that wasn't there when the query was created.

 

[Alex Blakenburg]

Can you click on the source line in the Power Query sheet and send me what appears there.
When I try to replicate it, Power Query automatically converts my input range to a Table and once its a Table adding columns automatically show up in my Power Query.
In my case it looks like this.
= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]

 

[RoryA]

You'll most likely just need to edit the step that removes columns. How you do that will depend on whether you used 'Remove columns' or 'Remove other columns'