Hi, I recently made a pivot table out of a large data file. I clicked on cells in the pivot table to see specific data behing the summary in the cell. Somehow later I found out that the original data source feeding the pivot table was all distorted. This is very confusing, can I trust pivot tables again?!!! Let me know if anyone knows what happened and how to avoid this in future.