Defer Excel Pivot Table Updates Excel Tip

SUBSCRIBE TO THE EXCEL AT EXCEL NEWSLETTER - 3 FREE Excel Tips First Wednesday of EVERY month. Join US!
Click the link below
www.howtoexcela... and get my free Top Tips for Excel Ebook Immediately
Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the www.howtoexcela... blog.
Be Social & Let's Connect
++Website www.howtoexcela...
++Twitter / howtoexcelatex
++Pinterest / howtoexcelat
Learn How To Create Your First Pivot Table
• Excel Tips- Create You...
Hello Excellers, today I show you how to defer updates to your pivot tables. This feature in pivot tables is a very small one but a very useful one in certain circumstances.
In this Excel video tutorial learn how to defer your Excel Pivot Table updating every time you move, add or delete a field.
So, with my Pivot Table example here, if I add Region to the Pivot table it updates, similarly if I remove region it updates once again in real time.
For pivot tables based on very large data sets, this can take some time to complete or update every time you move a field.
You can however actually control when the Pivot table is updated. There is a checkbox at the bottom of the field list which is called Defer Layout Update.
So, when you check or tick that checkbox, it is enabled which means that now you can add, remove and move fields around without the PivotTable updating itself.
When you are finished arranging fields, you press the Update button, and the PivotTable does only one update. So, no matter how many updates you carry out, and lets take an example here
Let's add in Region then surname, remove surname again. The Pivot Table has not updated.
I am ready to update it now so I press update. only one final update is carried out.
This is really useful if you have really large data sets which will only update once when you are ready.
That's folks, how to defer your Pivot Table updates.!

[@hazemali382]

Great video Many Thanks

[@Howtoexcelatexcel]

Hazem Ali
You’re Welcome!

[@hazemali382]

​@@Howtoexcelatexcel Many Thanks for reply ♥

[@pradnyahasabnis1107]

Thank you

[@Howtoexcelatexcel]

Pradnya Hasabnis
You’re welcome!

[@MisterWordExpert]

If the data was record in database style, you can create pivottable without select entire source data

[@cagalliawesome]

Can I check if macbook excel does not have the defer layout update? As I do not see it in my excel macbook

[@Howtoexcelatexcel]

Hello
I do not believe it is available for Excel for Mac

[@cagalliawesome]

@@Howtoexcelatexcel Hi, Noted with thanks :)

[@himanshuargade9018]

By the way you have nice Voice!

[@Howtoexcelatexcel]

thanks for the feedback - regards