Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
116
Views
Topic starter
Hello,
I like to have a column to have a specific width, but when I refresh Power Query, the table column resizes and I need to manually make the column wider again. Is there any way Power Query table honour the width which I manually set for a column and not resize the column width all the time? I have been looking around the options but could not find anything.
regards
Posted : 13/12/2019 6:49 am
Hi Maccra,
I'm not aware of any way to prevent Power Query resizing Table column widths, sorry. You could try Worksheet protection, but this may prevent the query loading.
Mynda
Posted : 13/12/2019 7:24 pm
Topic starter
I found a solution to this by unchecking "Adjust column width" under the "Table Design" tab for the PQ table. See attached screenshot.
Posted : 21/09/2020 11:28 am
Nice! Thanks for sharing.
Posted : 21/09/2020 7:04 pm
