How to automatically add and refresh new data in Pivot Table in Excel

This video is about how to make pivot table data range dynamic in excel. We can automatically add and refresh data in the pivot table by using offset and counta formula. This is very useful when we have to regularly update pivot table data because changing data source and refreshing might be a boring process when we change the source data. Watch video till the end and be able to create a dynamic pivot table range.

[@132barcelona]

is it possible to auto-refresh the pivot without VBA/xlsm?

[@kundandhanik3508]

You are really smart sir thanks😊

[@danielmarinas]

Fantastic! Thanks a lot
😊👍🏼

[@Nickenthechiken]

Hi, this is very helpful, thank you for the video! May i ask, would this function properly in a Shared excel workbook? For example, a workbook stored on a shared drive which is accessed by and edited by multiple people on a regular basis?

[@smart-office12]

This is made with excel vba, it only works in dextop

[@ajaybote3377]

can you tell me the code if my pivot table in other sheet how to refresh table

[@051sudharsan8]

thanks