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

Dave wrote:
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? Its embedded somewhere, or the pivot table
would not work.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html