I am unable to pull retrieve data in an Excel 2007 Pivot from an access query. I can see the field list and build the pivot but no data is retrieved until I change the access query to a table. Is this a connection, parameter issue or is there a patch to fix this problem? Is there a solution?