Thread: Column width
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
rml rml is offline
external usenet poster
 
Posts: 50
Default Column width

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