PivotTable.ConvertToFormulas Method
The ConvertToFormulas method is new in Microsoft Office Excel and is used for converting a PivotTable to cube formulas. Read/write Boolean.
Version Information
Version Added: Excel
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.
| Visual Basic for Applications |
|---|
|