Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot Table Data Source | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Pivot Table Data source | Excel Programming |