I have a spreadsheet with 14 (or so) tabs that contain pivot tables from MSAccess database.
I need to make certain that these are all pulling data from the same database, hopefully without rebuilding them. The only way that I have found to determine the datasource is to go into each tab, into the Pivot Table wizard and view the SQL to determine the path and file name of the source data.
Is there any other way to determine what datasources are being used? Is it possible to do this for the entire document instead of each tab?