ListObject.Refresh Method (2007 System)
Updates the ListObject control with current data and schema from a server that is running Microsoft Windows SharePoint Services.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Sub Refresh
'Usage
Dim instance As ListObject
instance.Refresh()
public void Refresh()
public:
void Refresh()
public function Refresh()
Remarks
This method can be used only with ListObject controls that are linked to a SharePoint site. If the SharePoint site is not available, calling this method will cause an exception to be thrown.
Calling this method does not commit changes to the ListObject in the Excel workbook. Uncommitted changes in the list object in Excel are discarded when the Refresh method is called. To avoid losing any uncommitted changes, call the UpdateChanges method of the ListObject control before calling the Refresh method.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.