Turn off pivot update

Seamus2626
Seamus2626 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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
Try the "Defer Layout Update" box on the Pivot Table Fields menu.
See picture
Capture.PNG

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial