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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse 2
Unable to Group in Pivot Table 1
Pivot table multiple filters 2
How I can set dynamic pivot table ONLY when I have enough data point 1
How do I change source data range for an existing Pivot Table? 1
Pivot Table Question 2
Used Range and Source data of a Pivot Table 1
Please help! Cannot open pivotTable source file.... 2

Back
Top