I keep reading how PowerPivot lets Excel process "millions of rows" (!!). I'm already doing this with a regular old pivot table hooked up to a (relational) SQL database. What does PowerPivot do differently?
You can read the datasheet for more info.
In short, it seems that it was built more efficiently, to handle larger data loads, automatically parallelizes across cores, and has more analysis tools.