BookmarkSubscribeRSS Feed
Cullima
Calcite | Level 5
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?
1 REPLY 1
CaseySmith
SAS Employee
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.

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users