I inserted new columns in a table I use in (2) pivot tables. Now when I refresh the data in the pivot table excel restarts, the doc is recovered with no explanation or data under show repairs. I've have no idea what to check for. I did copy and edit this workbook from my last project. There are data field in the fields list that I don't see in the table and I can't seem to find them. I've tried creating the pivot tables from scratch but still no change. Can you assist please.
