You have to have PowerPivot enabled (if available) on your Excel and then: Power Pivot->Manage->Existing Connections-> Change location for each connection. Also you would need to change psConfig.txt file area PSDataFolder to direct where PSData folder is located.
Comments
Power Pivot->Manage->Existing Connections-> Change location for each connection.
Also you would need to change psConfig.txt file area PSDataFolder to direct where PSData folder is located.