Microsoft Excel Add-in

[Nhozza]

Hi

I have the SAS add-in in excel. I have multiple SAS data sets in one excel sheet. Is there some way that I can refresh all at the same time without clicking on each data set and then clicking refresh.

Thanks

[KenjiAneel]

You can use VBA for this:

https://communities.sas.com/thread/9310?start=0&tstart=0

[mfab]

Hey Nhozza,

you may want to go to the SAS-Ribbon and click the 'Manage Content' button.

It should be a piece of cake from there on.

Just check the data you want to refresh and press refresh...

🙂

Cheers

Michael