PivotCache.RefreshDate Property

Returns the date on which the PivotTable cache was last refreshed.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
ReadOnly Property RefreshDate As DateTime
    Get
'Usage
Dim instance As PivotCache
Dim value As DateTime

value = instance.RefreshDate
DateTime RefreshDate { get; }

Property Value

Type: System.DateTime

Remarks

The cache must have at least one PivotTable report associated with it.

For OLAP data sources, this property is updated after each query.

See Also

Reference

PivotCache Interface

PivotCache Members

Microsoft.Office.Interop.Excel Namespace