Art
You could try un-checking 'adjust column widths' in 'Data range properties'
by right-clicking on the external data table. You could also, if this
fails, put some code in the Worksheet_Change() event like so
Private Sub Worksheet_Change(ByVal Target As Range)
Columns.AutoFit
End Sub
This way any entry in the worksheet that contains the code will autofit the
data
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Art" wrote in message
...
I have developed a great sheet with 4 separate SQL queries to give users a
report card.
All works wonderfully except that each time the sheet auto-refreshes, my
column widths compress down which makes the sheet hard to read.
Is there a way to lock down the colum width so it doesn't change?
Thanks