Microsoft KB Archive/241494

= "PivotTable is not valid" error message when you work with an Excel 2000 PivotTable in Excel 97 =

Article ID: 241494

Article Last Modified on 12/3/2004

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q241494





SYMPTOMS
When you activate a PivotTable in Microsoft Excel 97, and you click one of the buttons on the PivotTable toolbar, either nothing happens or you receive the following error message:

PivotTable is not valid.



CAUSE
This error message may occur if both of the following conditions are true:
 * The PivotTable was created in Excel 2000.

-and-
 * The PivotTable was created using an Online Analytical Processing (OLAP) database.

You are not able to perform any PivotTable functions on the PivotTables you created in Excel 2000 using an OLAP database as the source.



MORE INFORMATION
Microsoft Excel 2000 provides the ability to work with data from OLAP data sources in your PivotTable. This functionality does not exist in earlier versions of Excel, and when you open a workbook with a PivotTable created from an OLAP data source, the PivotTable is read-only.

For additional information about PivotTables created from OLAP data sources and compatibility issues, click the article number below to view the article in the Microsoft Knowledge Base:

234700 XL2000: Differences Between OLAP and Non-OLAP PivotTables

Keywords: kbprb KB241494

-

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

© Microsoft Corporation. All rights reserved.