ACC97: PivotTable Wizard Fails with Parameter Query in Microsoft Access (166355)
The information in this article applies to:
This article was previously published under Q166355 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When the data source that is used in the PivotTable Wizard is a query that
contains a parameter, 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 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.
STATUS
This behavior is by design of Microsoft Excel.
REFERENCES
For more information about the PivotTable Wizard, search the Help Index for
"PivotTables, creating," or ask the Microsoft Access 97 Office Assistant.
Modification Type: | Major | Last Reviewed: | 9/26/2003 |
---|
Keywords: | kberrmsg kbprb KB166355 |
---|
|