It's very easy to do with PowerPivot in Excel 2010 - that's essentially what it was designed to do. Not sure how to do it in Excel 2008. If you're thinking of making the upgrade leap, you now have one more reason to give it a shot.