Just got PowerPivot last month. I heard lots of good things about it but I was particularly interested in its ability to load data from any websites, e.g. Federal Statistics, Census data, my roulette plays, etc.
Heard it was as easy as copy from the column headers and paste into the PowerPivot window. It doesn't work. Did I miss out anything?