How to Update Pivot Table When Source Data Changes in Excel - Tutorial

Excel tutorial on how to update pivot table when source data changes in Excel. This can happen after you create a pivot table and then you have to update the pivot table with additional data. Or when you need to link your pivot table to a different data source.

We'll go over how to refresh the pivot table data, how to update the pivot table data when the source data in your Excel sheet changes, and how to link your pivot table to a different data source.

We'll end with how converting your data range to an Excel Table can help you never have to worry about updating your data source. This is because when a pivot table is linked to data in a Table format, new rows or columns of data automatically update in your pivot table once you refresh.

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[Dranach]

41 seconds into the video and my 2 week problem was solved. Thanks a lot. Not much information was given to me when my Dept. manager retired. Never have I dealt with a pivot table. This video made so much sense. Thanks again.

[MyBrewingSpace]

OMG! This is, by far, THE MOST STRAIGHTFORWARD video tutorial I've ever seen! You're the only one who actually solved my Excel problem for days! lol. Thank

[qianpiscessay]

I have watched so many videos about refreshing pivotable data， but only from urs I get the solution which I am looking for.

[delraydad]

THANK YOU FOR THIS! So simple to follow and understand.

[UdayKumar-byie]

I Just spent 46 seconds on this video and resolved my Isssue, so to the point awesome work :)

[CRSDelta]

this has changed my work life. thanks!

[mahfuzah.abdulrazak]

Thank god u save me from this problem at 4am...thank youu

[diannajablonski]

So helpful! Especially the part about formatting the source data as a table. Now I can add as much data as I want to before refreshing the pivot table. Thank you!

[feisty_bean]

Oh my gosh THANK YOU! You saved me so much work with this video!

[naveenraj]

Thanks, u have saved me from spending lot of hours on work

[siyandamakhathini]

Thanks the help at 1:29 seconds. God bless

[ModernFunWorldSwitzerland]

Very good explanation and it's very clear.

[nitantshah]

GREAT.THANK YOU SO MUCH.U SAVED MY BUCKS

[bakarrsesay]

Thanks so much for this video. I am so so happy this moment. You have just help me overcome a challenge I have been struggling with for weeks now. Thanks so much. Much 💕

[rameshmr]

Thank you so much your video helped me lot.

[xyz]

Pretty Good and to the point video. thanks

[ramagupta]

its very good explanation and very short video ..Thanks lot..

[bharathamal]

Before I got this video tutorial, I waste my whole day ... thanks for the video 😢😊😊

[blancitothegent]

thank you!! i knew it had to be this easy!!! very helpful video!

[CORRUPTIONCZARNETWORK]

wow, I'm impressed, It's was my pleasure meeting you today. I wish you success on your youtube journey, " corruption czar"