Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Pivot Table columns disappear or duplicate on change - corruption???

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

  • Monday, April 23, 2012 8:17 AM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Wednesday, May 02, 2012 10:07 AM
     
     
    Sign In to Vote
    0

    could you please refer the link here given.

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

     
  • Thursday, May 03, 2012 8:59 AM
     
     
    Sign In to Vote
    0
    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.