XL2000: DataType Property Always Returns xlNumber in OLAP PivotTables (210783)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q210783

SYMPTOMS

When you query the DataType property of a PivotTable field in a Visual Basic for Applications procedure, the procedure indicates that the data type of the field is numeric when the data type of the field is text.

CAUSE

This problem occurs when your PivotTable data is based on an Online Analytical Processing (OLAP) data source.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbdtacode kbpending KB210783
©2004 Microsoft Corporation. All rights reserved.