• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4295
  • Last Modified:

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...
2 Solutions
Rory ArchibaldCommented:
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.
Patrick MatthewsCommented:
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/
agwalshAuthor Commented:
As I suspected but good to have it confirmed :-)

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now