7.5. Linking a List in Excel to SharePoint

In this section, I will assume that you have successfully installed the Excel add-in mentioned in the previous section that allows you to synchronize Excel 2007 tables with SharePoint. In fact, I will start with a basic spreadsheet shown in Figure 7-22 that contains some data on America's fleet of space shuttles that NASA has built and flown for the past 30 years.

Figure 7.22. Shuttle list created in Excel 2007 but saved in 2003 format

As you can see in this figure, the worksheet contains a simple set of data consisting of four columns and five rows. (If you're a space enthusiast who is wondering what ...

Get Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.