After a period of time using pivot tables all over Excel, I now discover PowerPivot. And wow I do not know how I have missed out on this. Incredible. Now I have more powerful PivotTables. Or rather, now I can cut down on the vlookups. If you are a intensive Excel user, check it out at PowerPivot.com
- Allows millions of rows of data
- Allows tables to be linked together with unique keys
- Reuse data from multiple sources
- In some ways better and more convenient than Access
- Totally free