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
Article ID: 1087, Created: January 9, 2012 at 3:14 PM, Modified: May 9, 2012 at 6:52 PM