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...
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...
Asked:
Who is Participating?
LVL 85
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.
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/
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.
