sethmeister21
New Member
- Joined
- Mar 10, 2010
- Messages
- 20
I have a question about Pivot Table data....i.e. the data behind the Pivot.
Basically there is a report distributed around the firm... in the form of a very large pivot table with all the Pivot filters hidden and formatted so it just looks like like a few tables. But the source data has been DELETED. Is there a way to recover this data? To extract it and dump into a new tab?
One feature of the Pivot Table is that you can click on any cell and it will create a new tab (labelled Sheet1, Sheet2 etc) with the data that formed that cell but I want the whole data set that created the Pivot Table in the first place.
This may be an obvious one - any help greatly appreciated!
regards
S
Basically there is a report distributed around the firm... in the form of a very large pivot table with all the Pivot filters hidden and formatted so it just looks like like a few tables. But the source data has been DELETED. Is there a way to recover this data? To extract it and dump into a new tab?
One feature of the Pivot Table is that you can click on any cell and it will create a new tab (labelled Sheet1, Sheet2 etc) with the data that formed that cell but I want the whole data set that created the Pivot Table in the first place.
This may be an obvious one - any help greatly appreciated!
regards
S