Feedback by UserVoice

nahcr

My feedback

  1. 55 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    nahcr commented  · 

    a related error is that if you have a pivot using a table and you change the number of columns in the table, especially if you delete columns, all the pivots that refer to that table lose the source columns and you have to go in and manually correct every single pivot to change the source columns. i think this is related to using a table but not sure - it may also be having many columns like more than 26. and the same problem is involved - the error message does not tell you which pivots are a problem so you have to check every worksheet.

Feedback and Knowledge Base