Templated Excel workbooks with PowerPivot and Macro's

A often asked question is: "Can I create a templated report where I can create a PowerPivot workbook for my customers that will point to a database on the customers network". This can be very useful for example as an ISV where you have a product that is installed on a customers domain and has all its data in a database but the database server name is different at each customer. You still want to give out a PowerPivot workbook that just automatically gets its data from the right database so they can do their analysis on their own data, It would be very nice if we can package the PowerPivot workbook with the client application when installing on the clients machine.