Source data of a pivot table
 

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Source data of a pivot table
 

Beto wrote in news:btc80l$5ev3b$1@ID-
95421.news.uni-berlin.de:

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.



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