BookmarkSubscribeRSS Feed
Cullima
Calcite | Level 5
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??
1 REPLY 1
CaseySmith
SAS Employee
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.

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 702 views
  • 0 likes
  • 2 in conversation