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.
COURSE of the MONTH
15 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Defer layout update on pivot table - where and when?
Posted on 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...
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...
[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
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.
Active 4 days ago
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/
Featured Post
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…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll
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.