Automatically change Range of Pivot Table when data is added | Microsoft Excel Tutorial

In this Excel Tutorial I'm teaching you how to create Dynamic Pivot Table which will change the range automatically and add any new rows that has been added in the data set into the Pivot Table.

[r.p.]

I just Applauded you! This has SAVED me so much extra work and stress! I deal with big data and every time I add new data to Pivots set up with "Add to Data Model, " which I have to use to total unique values, the table goes BLANK. Now I see that if I create the Pivot Table from a named Table, that problem goes AWAY! Now I no longer need to re-create MULTIPLE pivot tables every time! GENIUS!

[r.p.]

Super video! I applauded for $10.00 👏👏👏

[Nicholi]

Great tutorial. I looked into auto-refreshing the pivot when data is added. I found that it is possible using VBA. Using this guide + a VBA refreshing guide will help you all achieve that 100% set it and forget it pivot table :)

[kevinfilcik]

Excellent explanation of two ways to create a dynamic pivot table. Thank you!

[jptnindia]

Thanks a lot. Really very helpful one. Saves days/weeks of work every year.

[TasmanOutdoors]

Thankyou so very much this was the answer I have been looking for. Your English is great and you made this solution very clear. With very warm wishes from Tasmania, Australia! :)

[shindepratibha]

Thank you so much for this wonderful video. It really helped me. I just have a question. How to refresh pivot tables in protected sheet?

[tshepisokabomo]

Wow, that just saved my day, very helpful. Thank You.

[visioneyenet]

very useful that saved my monthly reports thank you somuch

[emanuelmbassi]

It really works
you saved my day thank you!!

[davidprashad]

Awesome!
This technique is adding new information at the bottom of the pivot table without sorting & rearranging the alphabetical order.
But I wanted to know if I already have notes in the column next to pivot table for existing lines, do I have to rearrange notes ?

[rabdu]

Thanks a lot for the clear explanation. but please try to enable us to download the excel sheet you used. it will be more useful.

[foodietheprincess]

Excellent! That was VERY helpful! Thank you so much for sharing your knowledge!

[daracahill]

Very clear and easy to follow tutorial :) thanks

[lalala]

Thank you sooo much, thats help me aloooot

[BeyondTheGlobes]

What help offset did? Even a simple sheet bound with Table also does the same.

[eardops]

If I want to change apple with another fruit or I want to delet previous data and insert new data and refresh so can i get the pivot on same table

[VallabhaiR]

2 questions.. 1) does the second method refresh even if I add columns ? 2) i have neither created a table nor a formula is there a way to refresh after the pivot is created ?

[rajeshb]

Hello, Thank you for sharing the video, however in the dynamic pivot, i have one question to ask, in dynamic pivot when we add the data it will automatically pics the new data added as well, however if we insert a new column & add data, this does not work, can you pls explain why?, Thank you in advance.

[criclab]

How to change replace the names... Like if I want to replace apple with banana...? It should appear all places in the pivot table with one input.. is it possible..?