Defer layout update on pivot table - where and when?

hi Folks
Probably a pretty simple question...when creating a pivot table  - at the bottom of the pivot table field list, there is an option to "defer layout update". When and why would you use or not use this option? Thanks...
LVL 1
agwalshAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
If your pivot table takes a long time to calculate and you are about to make more than one change to it, it's worth checking that option so that it only updates at the end when you have finished making changes.
0
 
Patrick MatthewsConnect With a Mentor Commented:
You may want to check out this brief but useful blog post about it my Excel MVP Mike Alexander: http://datapigtechnologies.com/blog/index.php/speeding-up-pivottable-updates/
0
 
agwalshAuthor Commented:
As I suspected but good to have it confirmed :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.