PivotTable.CalculateData

PivotTable.CalculateData method

Calculates pivottable’s data to cells.

public void CalculateData()

Remarks

Cell.Value in the pivot range could not return the correct result if the method is not been called. This method calculates data with an inner pivot cache,not original data source. So if the data source is changed, please call RefreshData() method first.

See Also