| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - How To Obtain a External data Source??
Can you click on the pivottable, show the pivottable wizard and go back a few
steps? Galileogali wrote: I have got a Pivot table. The data Source is External (from another xls). I do not have this file. How can retrieve the data Source? I make "ShowDetails" (or Double-Click) on Grand Total Cell I got to incomplete Table. One field show me the same value "S / FRA" (my MS Office version is in spanish) -- GaliloGali http://excelgali.mejorforo.net/ in spanish -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot table - How To Obtain a External data Source??
Yes, the wizard Pivot table shows the original Path of the data Source
(already inexistent). I search to work with the PivotCache. It's Possible? How? -- GaliloGali http://excelgali.mejorforo.net/ in spanish "Dave Peterson" wrote: Can you click on the pivottable, show the pivottable wizard and go back a few steps? Galileogali wrote: I have got a Pivot table. The data Source is External (from another xls). I do not have this file. How can retrieve the data Source? I make "ShowDetails" (or Double-Click) on Grand Total Cell I got to incomplete Table. One field show me the same value "S / FRA" (my MS Office version is in spanish) -- GaliloGali http://excelgali.mejorforo.net/ in spanish -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
| Selected Columns to be Used in External Data Source in Pivot Table | Excel Discussion (Misc queries) | |||
| DATE FORMAT IN PIVOT TABLE FROM EXTERNAL DATA SOURCE | Excel Discussion (Misc queries) | |||
| Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
| group pivot table from external source | Excel Programming | |||
Linear Mode
