To do this, select a cell in the Pivot Table, display the Options tab of the ribbon, click the Change Data Source tool in the Data group, and finally choose Change Data Source. Make sure the cell range in the Table/Range field reflects accurately the range you want included in the Pivot Table.
With pivot tables, it's often the little things that are frustrating..doesn't show up when you refresh, number formatting goes missing, fields have weird names...things like that.
In this short video, we look at 10 common pivot table problems 10 easy fixes.
Updating changes is simple enough, but there is probably an additional step you will want to take if you have added records to your data table.
If you have added information at the end of the data table, either manually or using a data form, you will want to redefine the data range used to create the Pivot Table.
Microsoft's Excel spreadsheet application is designed to allow users to organize and interpret their data using advanced features such as pivot tables, formulas and macros.
Occasionally, users of these spreadsheets may need to edit or alter the data in order to answer questions about the results.Refresh | Change Data Source Any changes you make to the data set are not automatically picked up by the pivot table. Refresh the pivot table or change the data source to update the pivot table with the applied changes. You can also refresh data from a source table in the same or a different workbook.And you can set your workbook to refresh its Pivot Table data automatically when you open it.At any time, you can click Refresh to update the data for the Pivot Tables in your workbook.