Why is the PivotTable data source reference invalid?

Reason: The default reference of the pivot table is absolute reference. When the data table is moved, the area associated with the pivot table is still the original area and will not move with the movement of the data table. The data source reference will be invalid. Solution: Re-select the data and insert the pivot table; or change the data source directly.

The pivot table defaults to an absolute reference. When the data table is moved, the area associated with the pivot table remains the original area and will not follow the data. The table moves. Select the data again and insert the pivot table. Or change the data source directly.

The method to change the data source is as follows:

1. Create a new blank EXCEL worksheet, and then enter the data to create a pivot table. Select some data, then click Insert, PivotTable, and drag the fields.

2. In the PivotTable, click the PivotTable, then find the Analysis menu in the upper ribbon, click Analysis, and find Change Data Source in the pop-up tab. .

3. Click Change Data Source, and then a new dialog box pops up. This is the original area of ​​the pivot table we made, as shown in the figure. We can see that the area Only 14 rows are selected, which does not completely cover the data. Just click OK.

After confirmation, we can see that the original data has changed and the data is correct.

Processing Source Data

Pivot Table: An interactive, cross-tabulation Excel report for analyzing multiple sources (including external data from Excel) Summarize and analyze data (such as database records) or pivot chart reports.

Pivot Chart: A chart that provides interactive data analysis, similar to a Pivot Table. A variety of different source data are available when you can change the view of the data, see different levels of detail, or reorganize the layout of the chart by dragging fields and showing or hiding items in fields.

Source data: The data list or table used to create a PivotTable or PivotChart. The source data can come from an Excel data list or range, an external database or cube, or another PivotTable report type.

Related learning recommendations: excel basic tutorial

The above is the detailed content of Why is the PivotTable data source reference invalid?. For more information, please follow other related articles on the PHP Chinese website!