SharePoint List Synchronization

You can use SharePoint sites to store and present lists of useful information, including announcements, contacts, events, tasks, themes, and custom lists for other types of information. You can use Microsoft Office Excel 2003 and Microsoft Office Access 2003 to view and edit data stored in lists on SharePoint sites. This is a great way to share information with other users, make use of the information already published, and provide standardized lists of information (eg names of products or services of the company) that can be used throughout the company.



When Office 2003 is installed on your desktop computer, you can import data from a list on a SharePoint site to Excel 2003. You can then view, analyze, update and manipulate data in Excel. If you have the correct permissions on the SharePoint site, you can also use the data from Excel to update data online with the push of a button. Also you can export data from Excel 2003 or Access 2003 to generate a list on a SharePoint site, and can be used to generate an Access 2003 database table that is linked to data from the list on a SharePoint site. To build or import a list, you must be a member of a site group with the Manage Lists right for that SharePoint site.