Editing Lists Offline and Resolving Conflicts | SharePoint Tutorial pdf

Editing Lists Offline and Resolving Conflicts

The list in above Figure is linked to the list in SharePoint. You can add item in Excel and then synchronize those changes with SharePoint. That’s like working with documents offline, however only the cells with changes are sent to SharePoint. That lets Excel resolve conflicts with changes from other users on a cell-by-cell basis – when working with lists, merging your changes with others actually works!
Editing lists offline involves these tasks:
=> Add the synchronize commands to the Excel 2007 toolbar.
=> Make changes to the list and synchronize with SharePoint.
=> Resolve any conflicts that occur.
To display the list command in Excel 2007, add them to the Quick Access Toolbar:
1. Click the Office button®Excel Options®Customize®Commands Not in the Ribbon and select Synchronize List near the end of the commands list.
2. Click Add to add the command to the Quick Access toolbar.
3. Scroll up in the commands list, select Discard Changes and Refresh, and click Add.
4. Click OK to close the Customize page.
Figure 1 shows the list commands in both versions of Excel. Click Synchronize List to update both the worksheet and the SharePoint. Click Refresh to discard your changes and update the worksheet with data from the SharePoint.
Figure 1: Synchronizing a SharePoint list in Excel

If your changes conflict with changes made by someone else, Excel displays Figure 2 to resolve the conflicts.
Figure 2: Reconciling conflicting edits in a shared list

To replace the other member’s changes with yours, choose Retry My Changes.