Using Powerpivot & Excel workbook template for multiple databases

[jackmccarthy]

I am very green with excel and powerpivot please forgive me if I am not using the right terminolgy.

I have built a Powerpivot & excel workbook to work on a Player database and everything is working correctly. My problem is I need to load this in 15 different locations with 15 different set of data. What is the best way to save this file so when I go from location to location it loads correctly without database connection problems,also all tables in databases are named the same just different data in the tables.