Dynamically update Pivot Table when source data changes

How to automatically update a pivot table with new data, when for example new rows or columns are added to a pivot table? In this video, I show you how you can create a new Named range which is dynamic and changes to update the new information added. This is because it uses the Offset formula in Excel to continually keep updating the range of data. When the source data adds new columns or rows, the range expands. For the Pivot Table to update automatically, make sure the Data Source for the Pivot Table is linked to that dynamic range that you created using the Offset function.

Connect:

Course Alert:

Videos you may like:

Some Recommendations:
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance #shorts #dynamicrange #excelshortsvideo #exceltips

[vaquita]

This is amazing!!!
It also fixed the duplicates that had slightly different names for some reason!
Thank you!

[JWOA-jgfi]

I don't understand we're looking at a slice of video and we never get to see the formula in it's entirety.