:"PivotTable Operation Guide: Refresh Techniques and Data Source Updates"-Table skills免费ppt模版下载-道格办公

"PivotTable Operation Guide: Refresh Techniques and Data Source Updates"

After we modify the data source, how do we refresh the PivotTable? Taking this table as an example, we open the pivot table and change 6 in Xiao Chen's sales quantity D2 to 8. When you click on the PivotTable, you will see that the values are not updated synchronously. We select the pivot table area, right-click - Refresh, and you can see that the content is refreshed. If there are multiple pivot tables, you can choose to refresh them all. Select Data - Refresh All above the toolbar to complete the refresh. If you are worried about forgetting to refresh, you can right-click-PivotTable Options-Data-check "Refresh data when opening file" and click OK. This will automatically refresh the file every time it is reopened. The above situation applies to the situation where only table data is changed without adding rows and columns. Suppose we change the rows and columns of the data source, it is not possible to refresh directly. Let's add a column of data to the eighth row of the source table and try the operation. Click Refresh on the PivotTable and find that the data is not updated synchronously. At this time we need to change the data source. Click Analysis - Change Data Source - Select the new data source on the toolbar above the Pivot Table, click OK, and you will see that the data has been refreshed.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ju-tou-shi-biao-cao-zuo-zhi-nan-shua-xin-ji-qiao-yu-shu-ju-yuan-geng-xin.html