Pivot Table Data

D

Dave

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
 
T

Tevuna

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,...}
 
D

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.
 
R

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.
 
Top