Google Sheets数据透视表未更新 [英] Google Sheets Pivot Table Not Updating

问题描述

我有一个Google App脚本，可将信息提交到有组织的工作表中，并希望创建一个包含工作表中所有信息的数据透视表.我可以这样做，但是每当我向工作表提交新的数据行时，数据表就不会自动包含在数据表中.每次提交新的数据行时，我都必须手动更改数据透视表的范围.有什么方法可以使工作表/数据透视表自动包含新的数据行?

I have a google app script which submits info to an organized sheet and would like to create a pivot table with the all information in the sheet. I can do this, but whenever I submit a new row of data to the sheet, it is not automatically included in the pivot table. I have to manually change the range of the pivot table every time I submit a new row of data. Is there any way I can make the sheet/pivot table automatically include the new row of data?

推荐答案

我通过仅指定列范围来解决此问题.

I worked around this issue by only specifying the column range.

例如，如果在A至F列中有行数据，则将数据透视表的范围设置为SHEET！A:F

For example, if you have row data in columns A to F, set the range of the pivot table to SHEET!A:F

如果您现在添加行，则这些列中的新数据将被添加到数据透视表中.

If you add rows now, the new data in those columns will be added to the pivot table.

这篇关于Google Sheets数据透视表未更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！