Skip to Main Content
Excel 2003 Programming: A Developer's Notebook
book

Excel 2003 Programming: A Developer's Notebook

by Jeff Webb
August 2004
Intermediate to advanced content levelIntermediate to advanced
312 pages
8h 30m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 Programming: A Developer's Notebook

Update a Shared List

There are several ways to update a shared list:

  • Refreshing discards local changes and updates the (local) worksheet list with data from the SharePoint server.

  • Synchronizing updates both the worksheet list and the SharePoint list. Conflicts between local edits and edits from other users can be resolved by the user who is synchronizing.

Note

If you’re not upto- date, there’s no point in sharing.

How to do it

From Excel, use the Data List menu to refresh or synchronize a list.

From code, use the ListObject’s Refresh method to discard changes to the list on the worksheet and refresh it with data from the SharePoint server:

   lst.Refresh

Use the UpdateChanges method to synchronize the worksheet list with the SharePoint list:

   lst.UpdateChanges xlListConflictDialog

If two authors modify the same item in a list, a conflict will occur when the second author updates his list. The iConflictType argument determines what happens when a conflict occurs. Possible settings are:

SettingDescription

xlListConflictDialog

Displays the Resolve Conflicts and Errors dialog box to resolve the conflict (this the default).

xlListConflictRetryAllConflicts

Replaces conflicting data on the SharePoint server with data from the worksheet.

xlListConflictDiscardAllConflicts

Replaces conflicting data on the worksheet with updates from the SharePoint server.

xlListConflictError

Updates the items that do not conflict and generates an error—“Cannot update the list to Windows ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Office 2003 XML

Office 2003 XML

Simon St. Laurent, Mary McRae, Evan Lenz

Publisher Resources

ISBN: 0596007671Supplemental ContentCatalog PageErrata