Forum Discussion
Power Query Refresh - Freeze Panes and Auto-size columns
Hi All,
When I refresh my power queries and have the table set to resize columns on refresh, it works fine...
Until I freeze the panes on the table, to allow the top row and first column to stay visible while scrolling.
After this when I refresh the power query, all the columns are sized the same (to what seeems to be a default 80 pixels).
Is their any way to have freeze panes on but still resize the other columns based on the data when refreshed?
Cheers,
Stuart
Interesting finding, looks like a bug. I sent a frown, you may do the same (Help->Feedback->Report problem)
