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?

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