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 for reporting purposes. A week later, when the task list on SharePoint has gone through a number of changes, you can open the Excel spreadsheet from the document library and synchronize with the SharePoint list so that the spreadsheet and chart are up to date. This time you save back to the document library, and, if versioning is on, you have a nice trail of weekly status reports, with only the latest one visible in the document library.



    Sams Teach Yourself Microsoft SharePoint 2003 in 10 Minutes
    Sams Teach Yourself Microsoft SharePoint 2003 in 10 Minutes
    ISBN: 672327236
    EAN: N/A
    Year: 2004
    Pages: 181

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net