PivotTable.ConvertToFormulas (Excel)

The ConvertToFormulas method is used for converting a PivotTable to cube formulas.

The argument controls whether or not to convert the ReportFilter area of the PivotTable.

ConvertToFormulas (ConvertFilters)

ConvertFilters: Contains True or False to indicate the state of the ReportFilter area.


ActiveCell.PivotTable.ConvertToFormulas ConvertFilters:=True