How to update excel links automatically every 10 minutes

Good afternoon,

 

I’m trying to find a macro that will update all the excel links that I have in my woorkbook automatically at different intervals. For example I would need the links to update every 10 minutes once the sheet is opened. The links inside the worksheet are primarily connect to a query through SAS.

 

Is there any advice on how to create this macro or where to look for more information?

Any help is appreciated, Thank you.

By: Jeffrey

Leave a Reply

Your email address will not be published. Required fields are marked *