Excel Tables: Dynamic Data Sources for Your Excel Pivot Tables

Excel Tables: Dynamic Data Sources for Your Excel Pivot Tables

In this video I'll show you how to use Excel Tables to create dynamic data sources for your Excel Pivot Tables. This is super useful because if you're using a standard reference for your data source, you'll need to update your data source as data gets added to the set. By using Excel Tables, you make your data set dynamic so that every time you add a new record to your data set, your pivot table simply needs to be refreshed in order for the data to get updated again.

If you don't use a table, and you simply reference a range of cells, your data source needs to be updated before you refresh your Pivot Table.

Other Resources and Links

How to create a dynamic pivot table and refresh automatically in excel

Excel Pivot Table -- Dynamic Data Source - Contextures

How to Create a Pivot Table with Expanding Data Ranges - Excel Pivots

Formula Friday – Create A Dynamic Pivot Table Data Source Using OFFSET and COUNTA Functions

Excel video: Use a table for your next pivot table | Exceljet

Creating pivot tables with expanding ranges

Dynamically Change A Pivot Table's Data Source Range With This VBA Macro Code

How to make an Excel PIVOT table update automatically

How to automate your Excel models and reporting using dynamic Range?

Create a Dynamic Data Range with the OFFSET function

[doroncojocaru]

I have a question, I tried to create a pivot table in new sheet and with a macro to delete the raw data on the row sheet. the issue is that when i delete the data and add it again by copy the data it doesnt save my properties range, i tried also to name the rows and columns and had the same problem it somehow get it delete as example" =OFFSET(RawSatat!#REF!, 0, 0, COUNT(RawSatat!#REF!)+1, 46)" it put # FEF! instead of the columns i placed.

[CaravagioBaroque]

In my job, we have to copy and paste a new data set in each month. Is there a way to have the table remain?