How to retrieve source data from a pivot table

mich4442 Posted messages 2 Status Membre -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   -
Hello,

I accidentally lost the source data used in a pivot table.
However, I realize that this data is still stored internally by Excel (very large file, and a dump shows the deleted data).

Is it possible to use the pivot table to "restore" the lost source data?

Configuration: Windows XP / Chrome 22.0.1229.94

2 réponses

PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
Hello

Excel 2010
see menu
PivotTable Tools
Data
Change Data Source
you will have the address of the data used
Table/Range
4