Use Excel 2007 to grab live web data

“Can I use Excel 2007 to grab live web data?”. If that’s a question you’ve ever asked, or been asked, we have an answer..and that answer is yes 🙂

I saw this pretty cool video over at Community Clips showing how to do just that, and it’s surprisingly easy! I was expecting it to at least involve Pivot Tables but nope, there’s none of that-just a few logical clicks and away you go. One great feature is that each time you open the Excel sheet, the information will update!

This is one of those things where I can’t actually think of anything I could use this for right now, but I know that one day, for some reason, this is going to come in so handy it’ll be ridiculous!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s