O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required