View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default excel won't pickup an Access query for a pivot table

Does the query have any prompts in it... IIRC parametric queries don't work...
--
HTH...

Jim Thomlinson


"TechyTemp" wrote:

I am trying to set up a pivot table but when I click on the query in Access,
it won't pick it up. If I try other queries they pick up just fine. What
could possibly be wrong with that particular query?