Monday, April 23, 2012 8:17 AM
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?
Wednesday, May 02, 2012 10:07 AM
could you please refer the link here given.
Thursday, May 03, 2012 8:59 AMThat'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.