Pivot Table Data

[Guest]

I received a spreadsheet with a pivot table. If I double click a results
filed I see the data that rolls into the results. I do not see visibly see
any of the data any where in the spreadsheet to support the results unless I
double click it.

Where does Excel store the data? It’s embedded somewhere, or the pivot table
would not work.

Thanks

Dave K

 

[Guest]

The data might be:
a) Underneath the table
b) Hidden
c) Another tab

 

[Guest]

It is not on another tab, so how do I look at A & B below.

Thanks for responding

 

[Guest]

As for
a) drag the table to a side
b) unhide all columns and rows, or look if column and row headings are
sequenced {a,b,c,...},{1,2,3,...}

 

[Debra Dalgleish]

The data is stored in a hidden pivot cache, and can remain in the
workbook even if the original source data is deleted.

 

[Roger Govier]

Hi Dave

Perhaps the Sheet with the source data is hidden.
Invoke the PT wizard from the PT toolbar>Back and you should see the
source range.