1

I want to retain the column width and cell formatting whenever I refresh data in Power Query.

Data formatting under Table Tools > Design > External Table Data > Properties> unchecking "Adjust column width" does not work. Even after checking both "Preserve cell formatting" and "Preserve column sort/filter/layout"

Any work around?

1
  • Uncheck these 3 options in Properties.
    – Lee
    Dec 18, 2018 at 9:54

0

You must log in to answer this question.

Browse other questions tagged .