BookmarkSubscribeRSS Feed
Cullima
Calcite | Level 5
I still urgently need a solution to the problem I posted last week. Does anyone have any ideas:

" 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??"
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
If you have an urgent question, then you might consider working with SAS Technical Support. To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem". Alternately, you can go directly to the Tech Support Problem Form here:
http://support.sas.com/ctx/supportform/createForm

cynthia
Cullima
Calcite | Level 5
Have since resolved this problem. Execution options need to be set for each table individually (not sure why there is no global option?). In data set you want to update ion opening right click and select 'Properties', then 'Execution'. You should see a check box option for 'refresh on file open'. Repeat the process for each data set.

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
  • 2 replies
  • 651 views
  • 0 likes
  • 2 in conversation