Adding new columns to a single view changes all views

Dawn Phipps

Summary

Adding new columns to a single view changes all views

Content

Is there a setting that will stop this from happening?  I have several reports that have multiple views.  My main pivot table has many columns and then I have some aggregate views using pivots.  When I add new columns to the main pivot table (view) it also adds it to all other views in the report.  I then have to edit each and every view to remove the column.  Can this functionality be turned off?  It takes quite a while to open and edit each and every additional view in the report just to remove the column that was added.

Thanks for your help!

Dawn Phipps

Is this it?

Prudence K

Hi Dawn - yes, this is exactly what I came on to recommend!

Dawn Phipps

I have no idea if this is the fix or not.  I have not had a reply to my post or comment.  Still waiting.  If you find out this does indeed work, please let me know.