SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Preserve column width on refresh

Reply
Contributor
Posts: 33

Preserve column width on refresh

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?
SAS Super FREQ
Posts: 245

Re: Preserve column width on refresh

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.
Post a Question
Discussion Stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation