Synchronize list with SharePoint site

When you publish a list and choose to link the list, in order to manage synchronization between the local Microsoft Excel list and the SharePoint list, the List toolbar provides two buttons that allow you to choose how you wish to handle updates to the list.

To publish any local changes to the SharePoint list, and brings any changes made to the SharePoint list down to the local Excel list do the following:

• On the List toolbar, click Synchronize List  .

To discard local changes to the list, and download the current copy of the list from the Microsoft Windows SharePoint Services Web site do the following:

• On List toolbar, click Discard Changes and Refresh  .

Note  Synchronization is not automatic. Unlike a standard link in Excel (that is, between two cells), you must manually synchronize or discard local changes to the list. This is important because you are not prompted to do anything with local changes to a linked list when the file is saved or closed. You are notified when the file is opened only that the file has unsynchronized local changes.