Knowledge Base

ACC97: PivotTable Wizard Error Using Microsoft Excel 7.0 in Microsoft Access 97

Article ID: 167067

Article Last Modified on 1/19/2007

Microsoft Access 97 Standard Edition
Microsoft Excel 95 Standard Edition
Microsoft Excel 95a

This article was previously published under Q167067

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

If you try to invoke the PivotTable Wizard when you have Microsoft Excel version 7.0 or 7.0a installed, the PivotTable Wizard will return the following error message when it starts Microsoft Excel:

An error occurred while trying to use Microsoft Excel pivot wizard. Microsoft Excel returned the following error:

"Problems obtaining data."

CAUSE

The Microsoft Excel PivotTable Wizard Add-in that is included in Microsoft Access 97 is trying to open in Microsoft Excel 7.0 or 7.0a. The wizard was designed to work with Microsoft Excel 97.

RESOLUTION

You must have a copy of Microsoft Excel 97 installed on your computer before you can use the PivotTable Wizard in Microsoft Access 97.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

The following steps assume that you have Microsoft Excel 7.0 or 7.0a installed on your computer.

Open the sample database Northwind.mdb in Microsoft Access 97.
In the Database window, select the Forms tab, and then click New.
In the New Form box, click PivotTable Wizard and select the Categories table in the "Choose the table or query where the object's data comes from" box, and then click OK.
Click Next on the first screen of the PivotTable Wizard.
On the screen marked "Which fields would you like to include in your PivotTable?", add all the fields in the Available Fields box to the "Fields Chosen for Pivoting box," and then click Next.

Note that you receive the error message mentioned in the "Symptoms" section.

REFERENCES

For more information about using the PivotTable Wizard, search the Help Index for "PivotTables, creating," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbinterop kbprb KB167067