Learn how you can link an Excel 2010 workbook to a SharePoint 2010 list, and then configure Excel to refresh the data from the list, so you’re working with the current version of the data.

http://office.microsoft.com/en-us/sharepoint-foundation-help/video-link-an-excel-workbook-to-a-sharepoint-list-VA101887972.aspx