Microsoft KB Archive/301418

= OLAP cube data is returned alphabetically in a PivotTable report in Excel =

Article ID: 301418

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q301418



SYMPTOMS
When you create a PivotTable report that is based on data in an Online Analytical Processing (OLAP) cube that is offline (.cub file), Excel may sort the data by the first field alphabetically, even though the data wasn't sorted this way when the cube file was created.



WORKAROUND
To work around this problem, create your PivotTable report by querying directly from a data source other than an OLAP cube file, or modify the original data so that the first field is numeric and denotes the order in which your data should appear.

For example, if your original data set is a worksheet that contains January, February, March, April and May in a single column, add a column of numbers before the first column of data; add the new column to your defined names, and re-create the offline cube file.

Additional query words: XL2002 XL2000 xl2003 xl3007OLAP Cube Pivot Table ptable

Keywords: kbpending kbpivottable kbprb KB301418

-

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

© Microsoft Corporation. All rights reserved.