PrabasTech

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.

Want to receive weekly updates tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?