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.1. Exporting a List from SharePoint to Excel

The last couple chapters have covered exporting lists from SharePoint to Outlook and Access. So it should not surprise you that you can export a SharePoint list to Excel. In fact, if you have been checking out the options in SharePoint's list and document menus, you probably already have a good idea of how to start.

To show that document libraries act very much like lists, let's start with the Purchase Orders library. You previously used this library to learn how you could use library metadata in other Microsoft Office applications. You even created a custom view to sum the Purchase Amount column by department to produce a "report" within SharePoint showing how much each department spent during ...

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