Home  >  Article  >  Topics  >  Why is the PivotTable data source reference invalid?

Why is the PivotTable data source reference invalid?

青灯夜游
青灯夜游Original
2020-08-20 16:21:0782828browse

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.

Why is the PivotTable data source reference invalid?

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.

Why is the PivotTable data source reference invalid?

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. .

Why is the PivotTable data source reference invalid?

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.

Why is the PivotTable data source reference invalid?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn