Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Pivot Tables to Access Queries
I have developed several Pivot Tables, in Excel, which use a live link to an
Access Query. I am updating these queries to make them more comprehensive, across multiple time periods and have made them into Union queries. When linking these into a Excel Pivot Table, I receive an error stating there are too few parameters. Any ideas? |
#2
|
|||
|
|||
Presumably the query runs in Access without asking for input?
Try the Edit Query button on the External Data toolbar and see if MSQuery gives you any clues as to what it needs that has not been specified. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
pivot tables interface with queries | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |