I'm setting up a workbook with approximately six pivot tables per page. Each
pivot table is attached to a separate query in an external database. I've
just noticed, however, that all pivot tables on a page are pulling the same
data. What might be causing this? And how can I view the source of each
pivot table (the actual address of the queries, not the data produced by
drilling down) so I can verify that they're all attached correctly?