Recover Broken Data from a Pivot Table
How to Recover Broken Data from a Pivot Table
Data source is the back bone of a Pivot Table, it gets refreshed from the source and project the same as a summary as we wanted to. Sometime we mistakenly delete the data source and it is hard to recovery it back in some cases. In this Excel tutorial we are going to recover or get the deleted data in few simple steps.
- Double click on the last data of the pivot table in the total row
- The entire data set is been generated in a new excel tab
- You can resource the same to the pivot table
Download Excel
for Practice
If you watch and understand the entire tutorial along with the practice, it is a great time saver in such scenarios.
I hope you understood and practiced the entire concept. Thanks for your time for reading this article.