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


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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

Modification Type:MajorLast Reviewed:12/3/2004
Keywords:kbprb KB241494
©2004 Microsoft Corporation. All rights reserved.