Hello,

I'm working on a workbook which contains numerous pivot tables using 50 odd data connections, I need a quick way to find out what connection is used from the pivot table. At the moment I have to go through each connection to see which pivot table uses it.

Thanks