Explanation on Excel Pivot Table uning Reports in CRM

The explanation includes adding the excel file to the reports in the CRM and integrating them into the CRM environment.

http://blogs.msdn.com/crm/archive/2008/09/26/simplified-pivot-table-integration.aspx