It's really frustrating and there is no real way to stop it. I suspect you
know that you can highlight all the used columns and then double click in
the right split between the last highlighted column header and the first
unhighlighted one, (You cursor will change to an east/west arrow when you
are in the right place). This autofits the columns to the widest entry in
the column(s). This works in Access too, but Access only sizes to the
largest data in view, Excel's works better on all column data, whether
visible or not

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"rml" wrote in message
...
I have a sheet that connect to an access database. It updates data on my
sheet from a query in access. It works great. My problem is this: every
time I refresh or update the data, the column resizes to a default or
smaller
width. How can I freeze a columns width?

Thanks.