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.