Refreshing Multiple Datasets in SAS Add In for Excel

[Cullima]

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??

[CaseySmith]

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.