Updating tables in excel
PIVOT tables in Excel are common-place but not many analysts or Excel users create them so the PIVOT Table updates automatically to new data, learn how with this short guide that will save you time and impress your colleagues…
Excel PIVOT tables are a powerful tool for summarising raw data into more meaningful tables, reports and charts and due to these benefits you will find them in many Excel reports and dashboards.
How to make sure your PIVOT table updates the range automatically The first step is to create a dynamic named range for your dataset.
Normally, if you add additional data to your range, you will need to once again create the chart or at best change the range of cells on which the chart is based.
Once you have the dynamic range set up, you can create a pivot table, based on that range.
Excel shines at turning your data into charts—graphical representations of your data.
Make sure that there is a heading in every column, and no rows that are completely blank.
In the screen shot below, In Excel 2007 and later versions, you can format your list as a Named Table, and use that as the dynamic source for your Pivot Table.
There is, however a very good reason why pivot tables do not automatically update.