Pivot table - How To Obtain a External data Source??

G

Galileogali

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)
 
D

Dave Peterson

Can you click on the pivottable, show the pivottable wizard and go back a few
steps?
 
G

Galileogali

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?
 

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

Pivot table multiple filters 2
set data source dinamically 1
set data source dinamically 0
macro creating new pivot table 2
Used Range and Source data of a Pivot Table 1
Pivot Table 1
How do I change source data range for an existing Pivot Table? 1
Excel Error while updating an external data source into a pivot table! 0

Top