When loading Power Query as a table into Excel you can add formula to adjacent columns and they will copy down automatically. However when refreshed the formula does not copy down correctly unless you change Table Properties to Preserve Column Sort / Filter Layout https://www.linkedin.com/pulse/dont-get-caught-power-query-trap-wyn-hopkins
3 Comments
- Common sense fix. You've got my support Wyn
- Appears to be fixed in Latest Excel 2016 version
- Status added:Needs Votes
