Change the path to a Data Feed in a PowerPivot workbook

Creating the datafeed files, published them to the document library and if you wanna change the server name / change the site name in the datafeeds then here is the solution:

http://www.powerpivotblog.nl/import-data-into-the-model-using-a-macro-in-excel-2013/