Apr 07 2021 07:47 AM
Dear colleagues
I have a power query with an output to an excel table. After a power query refresh, the cell size is automatically updated to the largest value. Therefore, the checkbox “adjust column width” is enabled.
I open the workbook a next day and the cells are shrinked to the default width!
After a power query refresh, the cells size is automatically updated to the largest value (as same as first picture).
Why the cells are shrinked without any reason? This behavior does not happen every time and I cannot reproduce the issue. Is it a bug or a feature?
Thank You
Zdenek Moravec
Cesky Krumlov, Czech Republic
Apr 07 2021 08:26 AM
SolutionZdenek, if you uncheck "Adjust column width" column width will be as you set it manually (without changing), otherwise it changes it based on some logic in background.
Apr 07 2021 08:53 AM
I was thinking of this solution. The disadvantage is, that when new data come and they are very wide, they do not fit to my manually adjusted columns. Anyway I hope it is less devil for the customer then the shrinked cells.
Next workaround was to set the option “Refresh data when opening the file”. Because refresh query sets the columns width properly. But the "shrinked cells" issue appeared sometimes again. So it means, that the query was not refreshed after opening the workbook ... really strange. Is there any situation, that the query will not refresh despite the checkbox “Refresh data when opening the file”?
Apr 07 2021 10:20 AM
About refresh - if you checked refresh on opening it shall be refreshed. If that doesn't affect columns that doesn't mean query is not refreshed.
Apr 07 2021 08:26 AM
SolutionZdenek, if you uncheck "Adjust column width" column width will be as you set it manually (without changing), otherwise it changes it based on some logic in background.