preserving column sort/filter/layout when adding a column in power query

[DaveSomers]

using Excel 2016, I have a table built from PowerQuery, and then have additional columns calculated within the table. The source data now has an additional column that I'd like to pull in.
If I uncheck "preserve column sort/filter/layout", then I get the new column and lose all the calculated columns.
Leaving it checked, I never get the new column.

Is there a way to avoid having to rebuild the calculated columns but still get that new one?

 

[GraH]

Can you try this,
Insert a column in the Excel table up front and name it like it is named in the PQ output.
Then refresh without that option checked.

 

[DaveSomers]

Thanks for the suggestion GraH, and it lead me to try a few more permutations.
a) adding a mirror-named column before unchecking "preserve", then unchecking, editing the query and load = get new column, lose calculated columns
b) uncheck "preserve", add mirror-named column, editing the query and load = get new column, lose calculated columns
c) uncheck "preserve", add mirror-named column, check "preserve", edit the query and load = keep old columns, don't get new column
d) leave "preserve", add mirror-named column, edit the query and load = keep old columns, don't get new column, mirror column is just header
e) leave "preserve", edit the query and load = keep old columns, don't get new column.

Still looking for the magic ticket...