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.2. Exporting Data from an Excel Spreadsheet into a Custom List

In the last section, you saw that when you export a SharePoint list to Excel, you can manually update the Excel spreadsheet with changes made in SharePoint, but you cannot update SharePoint with changes made to the Excel spreadsheet. Let's now take a look at what you can do when you start from Excel 2007.

For the example shown here, I've created an Excel table that lists the top 30+ brightest stars in the evening skies. The table includes the name of the star, the name of the constellation in which the star can be found, and the star's apparent magnitude.

ABSOLUTE VS. RELATIVE BRIGHTNESS FOR THE LAYMAN

Apparent magnitude defines the relative brightness of the stars when you view ...

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