Excel Pivot Table Get External Data

[Tucker2008]

Hello,

I have several excel pivot tables that use ACCESS queries that I have created as the data source and they work great.

Is there any reason I would not be able to see some of the queries I have created when I am creating a Pivot Table and select 'Use External Data Source'??

I have several queries in the same DB and can see some but not all of them when I use this option.

Any/All help greatly appreciated

TM