PivotCache.SourceDataFile Property

  • Article
Excel Developer Reference

Returns a String value that indicates the source data file for the cache of the PivotTable.

Syntax

expression.SourceDataFile

expression   A variable that represents a PivotCache object.

Remarks

For file-based data sources (e.g. Access), the SourceDataFile property contains a fully qualified path to the source data file. It is set to Null for server-based data sources (e.g. SQL Server). The SourceDataFile property is set to Null if the Connection property is changed programmatically.

Example

This example determines if a connection exists for the cache and, if there is a connection, displays the data source file name. If no connection exists, the code handles the run-time error and notifies the user. This example assumes a PivotTable exists on the active worksheet.

Visual Basic for Applications 
  Sub CheckSourceConnection()

Dim pvtCache As PivotCache

Set pvtCache = Application.ActiveWorkbook.PivotCaches.Item(1)

On Error GoTo No_Connection

MsgBox "The data source connection is: " & _
    pvtCache.<strong>SourceDataFile</strong>
Exit Sub



No_Connection:
MsgBox "PivotCache source cannot be determined."


End Sub

See Also