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

Refreshing Multiple Datasets in SAS Add In for Excel

Reply
Contributor
Posts: 33

Refreshing Multiple Datasets in SAS Add In for Excel

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

Re: Refreshing Multiple Datasets in SAS Add In for Excel

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.
Ask a Question
Discussion stats
  • 1 reply
  • 158 views
  • 0 likes
  • 2 in conversation