I am importing data from a SAS table via the Excel Add-In. However, whenever I refresh the data the columns auto-fit to the data. I need to force it to preserve a set column width. Can anyone tell me how to do this?
On the Properties dialog of the data view (which you can get to from the SAS menu, toolbar, or context menu), on the Advanced tab, there is an option called "Adjust column widths" that is on by default. If you uncheck it, refreshes on that data view will leave the column widths as is.