EPM Central Project Server Tutorials
Home Deployment    MS Project PWA SharePoint Articles Administrators FAQs Consulting Guest Book Search Site Map
    WSS 3.0

Customization
Default Logo
Left Navigation
Top Navigation

Document Library
Overview
New Library
Upload Files
New Folder
Edit Documents
Version History
Advance Settings
Securing a Library

Lists
Overview
Deliverables
Custom List
List from Excel
Working with Excel

Email Alerts
Document Library
Lists

 
 
Working with Excel
Windows SharePoint Services is fully integrated with Microsoft Office Excel (Excel 2003/2007). When MS Excel installed on your machine, you can export SharePoint list to yourlocal machine that stays updated with changes to the original list in your SharePoint site. The Excel spreadsheet maintains a connection to the SharePoint list and therfore becomes a linked object.

Typically, SharePoint will contain the lists like Issues, Risks, Contacts and customized lists.

The following actions can be possible on lists
  1. Export list to Spreadsheet
  2. Perform Updates to list from Spreadsheet



1) Export list to Spreadsheet:



Save this file to your machine by giving any name. Close the file;




2) Perform Updates to list from Spreadsheet:

Please complete the step 1 before working on this step. Open the file saved in step 1.

Enter the new information in next available row (marked with *) OR Update the existing rows.

Please click on any cell of the content; Right click -> List -> Synchronize List

(OR)

On Data Menu -> List -> Synchronize List to updated the contents of Spreadsheet to the List on SharePoint site.








Copyright 2013. EPM Central. All rights reserved.