Browse to the Excel 2007 SharePoint list synchronizing add-in and choose "OK." Verify that "synchronizeWSSandExcel" is checked in the "Add-Ins" dialog box. Add the Add-in to the workbook you want ...

Mark Gerow, SharePoint expert at Fenwick & West, creates simple Excel spreadsheets that link to Microsoft SharePoint tasks, which shows how to apply everyday tools to accomplish complex results.