Pivot Table columns disappear or duplicate on change - corruption???

Question

I am in the process of building a large workbook for my business and all been going fine until today.  If i add a new clumn value it inserts it as "Sum of X". If I edit measure and make it average eithther the column disappears completely or i get both avergae and sum in the pivot table. The field list just shows "Sum of X" still.   I have to save, close and reopen the workbook for the coulmns to appear correctly.   Have I created some long term corruption that will palgue me forever? Is there a solution? Should I rewind to a version from a few days ago and start again?

Thanks Mike

Answer 1

could you please refer the link here given.

http://www.ehow.com/how_5977564_delete-field-pivot-table-excel.html

Answer 2

That's not the problem. I remove a field form the field list and it may go form the table ,but still be listed  or I change the calc form sum ot count and get both coluns in my table and only one in the field list.  If I close it down and repon ti sorts itself out. i think it is just a memory issue as the workbook gets bigger. Hoping to find a way to try it on 64-bit office.