ACC2000: PivotTable Wizard Fails with Parameter Query in Access (198930)
The information in this article applies to:
This article was previously published under Q198930 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you use a data source that contains a parameter in the Pivot Table Wizard, you may receive the following error message when the wizard tries to create the table:
An error occurred while trying to use the Microsoft Excel Pivot Table Wizard. Microsoft Excel returned the following error:
'Problems obtaining data.'
CAUSE
You cannot use a parameter query in the PivotTable Wizard. The data used in
the PivotTable Wizard must come from a table or a query that does not need
any additional input.
RESOLUTION
If you want to use a parameter query as the source for the data in the
PivotTable Wizard, you must first run the query and make a table of the
data; then, you can use that table in the PivotTable Wizard.
REFERENCESFor more information about creating a PivotTable, click Microsoft Access Help on the
Help menu, type pivot table in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
Modification Type: | Minor | Last Reviewed: | 7/13/2004 |
---|
Keywords: | kberrmsg kbprb KB198930 |
---|
|