There are 40 excel files in the folder and some on the share point site. Need to write a power shell script to refresh all those excel documents including power pivot table and data connections. I have partial script written. You just need to modify it need to implement for each loop as well. Also need to choose month from slicer using powershell script.