The source data range when the pivottable has a worksheet datasource. The number of columns in the range must be intact if this property is changed. The range must be in the same workbook as the pivottable.

public ExcelRangeBase SourceRange { get; set; }

Public Property SourceRange As ExcelRangeBase

public:
property ExcelRangeBase^ SourceRange {
	ExcelRangeBase^ get ();
	void set (ExcelRangeBase^ value);
}