Article ID: 213455 - Last Review: November 23, 2006 - Revision: 3.4 XL2000: Data Fields Are Not Included in PivotFields CollectionThis article was previously published under Q213455 SYMPTOMS
In Microsoft Excel, when you run a Microsoft Visual Basic for Applications macro that uses the PivotFields collection to return the fields in a PivotTable, the fields in the data area (DataFields object) are not returned.
CAUSE
This behavior can occur because the PivotFields collection does not contain
the DataFields object or the fields that are in the data area. Data fields
are created from pivot fields. For example, the data field "Sum of Profit"
is created by dragging the pivot field "Profit" to the data area on the
PivotTable in the PivotTable Wizard. Multiple data fields may be created
from the same pivot field.
WORKAROUNDMicrosoft provides programming examples for illustration only, without warranty either
expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose. This article assumes
that you are familiar with the programming language being demonstrated and the
tools used to create and debug procedures. Microsoft support professionals can
help explain the functionality of a particular procedure, but they will not
modify these examples to provide added functionality or construct procedures to
meet your specific needs. If you have limited programming experience, you may
want to contact a Microsoft Certified Partner or the Microsoft fee-based
consulting line at (800) 936-5200. For more information about Microsoft Certified
Partners, please visit the following Microsoft Web site:
https://partner.microsoft.com/global/30000104
(https://partner.microsoft.com/global/30000104)
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
(http://support.microsoft.com/default.aspx?scid=fh;en-us;cntactms)
You can create a macro that returns only the data fields in a PivotTable, by using the DataFields object.To create and run the macro DisplayDataFields, use the steps in the following example:
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
You can use the SourceName property of the PivotField object to
return the name of the pivot field as it appears in the original
source data for the pivot table. The Name property of the PivotField
object returns the name of the pivot field as it appears in the
table.
REFERENCESFor more information about the PivotFields Collection Object, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type pivot fields in the Office Assistant or the Answer Wizard, and then click Search to view the topic. For more information about the SourceName Property, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type sourcename in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Article Translations
|

Back to the top
