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