https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Preserve-column-width-on-refresh/m-p/75559#M1046 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? Tue, 13 Oct 2009 09:33:40 GMT Cullima 2009-10-13T09:33:40Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Preserve-column-width-on-refresh/m-p/75559#M1046 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? Tue, 13 Oct 2009 09:33:40 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Preserve-column-width-on-refresh/m-p/75559#M1046 Cullima 2009-10-13T09:33:40Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Preserve-column-width-on-refresh/m-p/75560#M1047 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. Tue, 13 Oct 2009 13:18:19 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Preserve-column-width-on-refresh/m-p/75560#M1047 CaseySmith 2009-10-13T13:18:19Z