55 votes12 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
This is something that clearly needs improvement, and we’re looking at it now. Please keep the votes coming as a way to help us prioritize this work. Thanks!
An error occurred while saving the commentnahcr 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.