BW (SAP Business Warehouse)
Connecting to SAP BW with Excel PivotTables and ODBO
This document illustrates a step-by-step description of the process that will get you connected to your data. Note that all steps presented here work the same way for Excel 2000, 2002, and 2003.