Why is Power Query is changing my column widths?

[Charley]

After I made a trivial edit to my M code, Power Query now changes the widths of all my columns in the target worksheet to 8.43, the default value of a new workbook.

Does anyone have an idea about why PQ is doing that and how to get it to stop?

 

[Ken Puls]

Hey Charley, that won't be a Power Query thing, but rather an Excel thing. Can you check the table properties and see if the Adjust Column Widths setting is on/off?

 

[Charley]

Ken,

That did it! It never occurred to me to check the Table's properties, because I had made no change to them in the first place.

Thanks, Ken!

Charley