Fixing Column Width Upon Data Refresh

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I've got a worksheet that goes and gets data from a SQL Server table
every time you open the file. I've set the worksheet up so that it
prints correctly - column widths, etc. However, when you close the
file and then open it again, the data refreshes (as it's supposed to)
and the columns all adjust to fit the data, thus blowing anyone's
ability to print the report without having to reformat the columns.

Can anyone tell me how I can lock the column widths so they don't
autosize upon refreshing my data?

Thanks,
Scott
 
I suggest you record a macro to reset your column widths.

Regards
BrianB
=================================================
 
Scott -

I had the same problem.

To solve it, I had the data imported into a separate worksheet insid
the workbook then copy the value(s) into the desired worksheet. i.e
=SUM(Sheet1!E5)

This way the "scratch" worksheet had the data and changed columns bu
the "printable" worksheet only grabbed the actual "value" from th
"scratch" worksheet.

Hope this helps.

Bil
 
Back
Top