View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Galileogali Galileogali is offline
external usenet poster
 
Posts: 1
Default 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