View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChuckW ChuckW is offline
external usenet poster
 
Posts: 23
Default Finding the Access query a pivot table is based on

Hi,

I took over some reporting from someone else who created pivot tables based
on some access queries. All I need to do is to refresh the pivot table to
get updated data. I want to find out which query in my access database the
pivot table is using but cannot seem to locate this. Is there a way in excel
to identify this?

Thanks,
--
Chuck W