7.3. A Quick Look at Excel 2003 and Synchronization

Because I've mentioned several times that Excel 2003 provides more functionality with SharePoint than Excel 2007, you may be discouraged about Excel's role in SharePoint's collaborative future. Before presenting a solution for the Excel 2007 user, let's take a quick look back at Excel 2003 and SharePoint.

7.3.1. Exporting a SharePoint List to Excel 2003

To export a SharePoint list to Excel 2003, you begin by selecting the SharePoint list you want to use and choosing Export to Spreadsheet from the Actions menu. As before, your computer first displays a dialog box asking whether you trust the source when SharePoint tries to send the IQY file. Click Open to allow your computer to download the ...

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.