| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking parameter query from Access to pivot table in Excel
I am trying to link an Access query that prompts for several criteria to an
Excel pivot table. When I refresh the pivot table, I want it to open the database and run the query to update the data in the pivot table automatically. When I try to link to the data source, when I get to the end of the "Query Wizard", it gives me the error of "Not enough parameters. Expected 4". But it never prompts me for the parameters. Please help. Is there a setting I need to change or do I link the query differently to avoid "Microsoft Query" tool? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
| Linking Pivot Tables to Access Queries | Links and Linking in Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| How do I get a web query to auto-refresh before a pivot table aut. | Excel Discussion (Misc queries) | |||
Threaded Mode
