Microsoft Office Tutorials and References
In Depth Information
Figure 20-44. The output of ListFormulas
Note that the ListFormulas method of the PivotTable object will produce a list (on a separate
worksheet) of all formulas in the pivot table. The outcome for the pivot table in Figure 20-43 is
shown in Figure 20-44 .
Figure 20-44. The output of ListFormulas
Let us conclude by recalling that the read-only IsCalculated property can be used to determine
whether or not a pivot field or pivot item is calculated.
 
Search JabSto ::




Custom Search