View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
needhelp needhelp is offline
external usenet poster
 
Posts: 4
Default Reformatting of cells on requery of sql source

Is there any way to prevent excel from reformatting the cell widths when the data is refreshed from the datasource. I have a worksheet that automatically refreshes when it is opened, but it reformats all of the column headers to fit the longest piece of data for that column.