Source data of a pivot table

  • Thread starter Thread starter Beto
  • Start date Start date
B

Beto

Hi,
Is there a way to know which one is the source of a pivot table made
from an external database?

I tried using the pivot table wizard, but the back button was disabled.
Regards,
 
Hi,
Is there a way to know which one is the source of a pivot table made
from an external database?

I tried using the pivot table wizard, but the back button was disabled.
Regards,
Click to expand...


While on your pivotsheet, do this :

alt F11

You should see a window called "direct" in the bottom
copypaste the string below in this window, replacing mypivot with the
actual sheetname and press <enter>


debug.print activesheet.pivottables("mypivot").sourcedata


If there is VBAcode in there somewhere, use CTRL F to find a "DSN" string.


regards

Ward
 
Back
Top