Microsoft KB Archive/210783

= XL2000: DataType Property Always Returns xlNumber in OLAP PivotTables =

Article ID: 210783

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: XL2000 tensor

Keywords: kbbug kbdtacode kbpending KB210783

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.