ListObject.Refresh Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the current data and schema for the list from the server that is running Microsoft Windows SharePoint Services.
public:
void Refresh();public void Refresh ();Public Sub Refresh ()Remarks
This method can be used only with lists that are linked to a SharePoint site. If the SharePoint site is not available, calling this method will return an error.
Calling the Refresh method does not commit changes to the list in the Excel workbook. Uncommitted changes in the list in Excel are discarded when the Refresh method is called. To avoid losing any uncommitted changes, call the UpdateChanges(XlListConflict) method of the ListObject object before calling the Refresh method.