Hi all
Currently I need to run (double click) to open an excel file, which consists of Data link to another Excel in Document Library (SharePoint). Basically, I need to open and save it and close daily, the purpose is just to let the PowerPivot table refresh the latest data
Is there a way to write a script to open and save at a dedicated timing of the day, without having man in loop to physically run it and save.
Currently I need to run (double click) to open an excel file, which consists of Data link to another Excel in Document Library (SharePoint). Basically, I need to open and save it and close daily, the purpose is just to let the PowerPivot table refresh the latest data
Is there a way to write a script to open and save at a dedicated timing of the day, without having man in loop to physically run it and save.
