?
Solved

Defer layout update on pivot table  - where and when?

Posted on 2013-01-07
3
Medium Priority
?
3,791 Views
Last Modified: 2013-01-07
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...
0
Comment
Question by:agwalsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1600 total points
ID: 38750676
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
 
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 400 total points
ID: 38750771
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
 

Author Closing Comment

by:agwalsh
ID: 38750803
As I suspected but good to have it confirmed :-)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question