How to retrieve source data from a pivot table

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 answers

  • Votes
  • Date
  • Descending date
  1. Contributor
    Hello

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