Pivot table reftresh

Hi Efstratia

Thank you for your question. If the source database is in an Excel spreadsheet and the new data is added below the original data then the Pivot table will not automatically include the new rows - even if you click refresh. Refresh reloads the contents of the original database, rather than adding the new lines.

One option is to use the Change Data Source button on the Pivot Table Ribbon. This lets you change the source range of data to include the new records by re-selecting them.

The other option is to format your source database in Excel as a Data Table then use this table as the base for the pivot table. To format as a table click in the data and on the Home tab click Format as Table and choose the format you wish for the data.

In a data table when you add new records at the bottom Excel automatically adds them to the table. If you use the refresh button in the pivot table it will now include the new rows of data in the results.

I hope this helps - let me know if you have any further questions or if your data is stored outside of Excel.

Kind regards,
Andrew