https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Refreshing-Multiple-Datasets-in-SAS-Add-In-for-Excel/m-p/74499#M1019 Yes, there is an option... check the "Refresh on file open" option on the Execution tab of the Properties dialog for each data view that you want to be refreshed when the workbook is opened. Mon, 17 Aug 2009 14:30:49 GMT CaseySmith 2009-08-17T14:30:49Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Refreshing-Multiple-Datasets-in-SAS-Add-In-for-Excel/m-p/74498#M1018 I have an Excel workbook with 4 seperate sheets, each linking to a different SAS data set. I want all 4 of these to refresh when I open the workbook, but this seems only to happen for the one of them. If I click the 'refresh multiple' this works but I need it to happen as soon as the workbook is opened. Is there an option somewhere I have missed?? Wed, 18 Feb 2009 16:04:24 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Refreshing-Multiple-Datasets-in-SAS-Add-In-for-Excel/m-p/74498#M1018 Cullima 2009-02-18T16:04:24Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Refreshing-Multiple-Datasets-in-SAS-Add-In-for-Excel/m-p/74499#M1019 Yes, there is an option... check the "Refresh on file open" option on the Execution tab of the Properties dialog for each data view that you want to be refreshed when the workbook is opened. Mon, 17 Aug 2009 14:30:49 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Refreshing-Multiple-Datasets-in-SAS-Add-In-for-Excel/m-p/74499#M1019 CaseySmith 2009-08-17T14:30:49Z