PivotTable.ConvertToFormulas Method (Excel)
The ConvertToFormulas method is new in Microsoft Office Excel 2007 and is used for converting a PivotTable to cube formulas. Read/write Boolean.
Version Information
Version Added: Excel 2007
Syntax
expression .ConvertToFormulas(ConvertFilters)
expression A variable that represents a PivotTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
ConvertFilters |
Required |
Boolean |
Contains True or False to indicate the state of the ReportFilter area. |
Remarks
The argument controls whether or not to convert the ReportFilter area of the PivotTable.
Example
In the following example the ReportFilter area is not converted.
Sub ConvertToCubeFormulas()
ActiveSheet.PivotTables("PivotTable1").ConvertToFormulas False
End Sub