Hi there. I've had a lot of trouble with one as well. In this case, are you
getting new columns of data when you refresh? If so, then you are getting
column size from some other setting somewhere (I never have figured that
out). The only way I've been able to solve this is by progromatically
adjusting column width on a refresh. Of course I'm terribly lazy so there
may actually be a better way but once I solved it, I just use that code... :)

If you are familiar with code, then you need to create a class module for the
query and then use the AfterRefresh event on the query table. Have it run a
function that adjusts the column width.

I would imagine that other people in this group would have a lot better code
than I do, but maybe this will be a start.

If you are not getting new columns then you should be able to select the
"Preserve Cell Format" check box off the "Table Settings" right click menu.

Hope it helps,
Nathan

"rml" wrote:

That does not work. When I refresh data, it still resizes the whole column.

"Debra Dalgleish" wrote:

Right-click on a cell in the table
Choose Data Range Properties
Remove the check mark from 'Adjust column width'
Click OK

rml wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html