Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Turn off pivot update

Hi - i need to make some changes to a bunch of pivots - can i turn off update the pivots as i keep getting "pivot will overlap" error



I am using Excel 2013
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Not sure what you mean about "turn off" but your error message is occurring  because you are changing the row/column length by adding fields so that the message "pivot will overlap" is telling you the revised pivot will overlay other data to the right or below the original pivot table.  If you don't want the message you need to move what is to the right or below the original pivot table to allow room for the "new" pivot table.
Avatar of Seamus2626

ASKER

As far as im aware there is a function within the PT to allow you to make changes in the field list and then update when you have made your changes
ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See picture
Capture.PNG