Fix the column width

[nc]

Hi all,
I am trying to fix the width of a column everytime I open it but I can't. After I have fixed the column width and saved it before I close the file, when i reopen it, the column width will expand. The data source of that column is a real time query. I tried to lock the cell but when i locked it, I can't refresh the data from the query as it is locked. So, is there any way for me to achieve that?
Any help?

regards,
nc

[zzydhf]

if you show the "external data" toolbar there is a button for "data range properties" one of the check boxes is for "adjust cloumn width".

turn it off.

ps your active cell must be in the query range for this to work

[nc]

Ok, I got it. Thanks!

Regards,
nc

[rizza]

if you show the "external data" toolbar there is a button for "data range properties" one of the check boxes is for "adjust cloumn width".

turn it off.

ps your active cell must be in the query range for this to work

hi,

was trying to do this, but i believe the method within 2003?
where can i find it on 2007?

thanks