I have successfully been using Powerpivot to display Pivot Tables and Charts for reporting based on linked Access queries for the last six months. I change the ODBC links in my Access project to point to a different SQL database, and then simply refresh the linked queries and the reports...