XL97: "PivotTable Is Not Valid" Error Working with Excel 2000 PivotTable

ID: Q241494

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you activate a PivotTable 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:

Q234700 XL2000: Differences Between OLAP and Non-OLAP PivotTables

Additional query words:

Keywords : kbdta xlpivot
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb