Queries - lock column width?

[Nick Dangr]

Is there a way to lock a column width in so that when using a
query-based spreadsheet, the column isn't resized each time the sheet
is refreshed?

 

[Nick Dangr]

I answered my own question. From excel you can modify the data range
properties. One checkbox was checked "Adjust column width". Uncheck
it and voila, no more column width changes.

I happen to be sure my column data won't exceed given widths - a note
to any who use this particular fix - if your data is wider than the
column and you've specified not to adjust column width, the column will
only show partial data.

<shrug>

Regards

Ben / ND

 

[salmanag]

cant find it. pls

Hi,


Could you advise me where the option "Adjust column width" is in Excel. ?

Regards,

Salman