Fix the column width

nc

New Member
Joined
May 13, 2002
Messages
23
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
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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
 
Upvote 0
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
 
Upvote 0
Is there anyway to change the default on this checkbox?

Lynnette



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
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top