Does PowerPivot from Microsoft works? Yes!

Hi!

I have been recently working with million of records.
Normal excel worksheets do not support more than 1.000.000 records or lines, as you prefer.
But I still have to work with excel (this is a client compliance).
How did I deal with that?
Using PowerPivot.
It imports 2.600.000 records in less than a minute.
The performance of his pivot table is as well as good.
So, if you are facing the same scenario as I am, PowerPivot can be your solution.

Good luck!