Any SharePoint list can be accessed as XML. If you use a URL like the following:

and use Excel 2003 to open it, you can link to it like any other XML.

  1. Choose Use the XML Source task pane:

  2. Choose the Elements you want to map:

  3. And then your List is linked to your Excel file:

  4. Use the List Toolbar in Excel to synchronize changes: