Pivot table stripped after "unreadable content" error encountered

Pivot tables can be difficult enough to work with by themselves, but it’s even more frustrating when Excel finds unreadable content in your workbook and strips the pivot table off the sheet. You may notice this problem after you refresh data in your pivot table, save the file, close it and then try to re-open…