Queries - lock column width?

N

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?
 
N

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
 
Top