Sams Teach Yourself Microsoft® SharePoint™ 2003 in 10 Minutes

Saving Your Excel Work

The more time is put into the Excel formatting, the more important it is to save your spreadsheet. Rather than saving it to your local hard drive or to a network folder, you can save your work to a document library on the same site that houses the list you have exported from. Then you can simply open the Excel document and synchronize the changes as discussed previously in this lesson.

This is a great way to export a list (such as the task list we have been working with in this lesson), make changes so the list prints nicely, include a chart in the file, and then save the file to a document library on the site (the ProServices site in this example). This Excel file could then be printed and given to a departmental manager ...