在Access 2013中编辑数据透视表内容 [英] Edit pivot table contents in Access 2013

问题描述

我有一个数据透视表，例如PivotA，还有另一个连接到其主键的表，例如TableB.我需要在数据透视视图中编辑TableB.

I have a pivot table, say PivotA, and another table left joined to its primary key, say TableB. I need to edit TableB in the pivot view.

是否可以完全编辑数据透视表的内容?当我尝试从任一源编辑单元格时，它告诉我记录集不可更新.这是一个非常模糊的错误，我还没有发现与我正在做的事情有关的任何原因.即使我在没有TableB的情况下重新创建数据透视表，我也会得到同样的结果.

Is it possible to edit the contents of a pivot table at all? When I try to edit a cell from either source, it tells me the recordset is not updateable. It's a very vague error and I haven't found any causes relating to what I'm doing. Even if I recreate the pivot without TableB, I get the same thing.

推荐答案

可更新的记录源是满足一些标准的记录源，以确保Access准确知道需要编辑的行.不幸的是，这些限制之一是无法在聚合或计算字段中对其进行更新.我相信在大多数情况下(即使不是全部情况下)，数据透视表都是基础数据的集合.因此，根据设计，您将无法更新数据透视表中的数据.

An updateable record source is one that fulfills a few standards to ensure that Access knows precisely which row needs to be edited. Unfortunately, one of those limitations is that it cannot be updated in an aggregation or calculated field. I believe in most if not all cases, a pivot table is an aggregation of the underlying data. So by design, you will not be able to update data in a pivot table.

这里是一个可以帮助您理解错误的链接:可更新的记录

Here is a link that may help understand your error: Updateable records

这篇关于在Access 2013中编辑数据透视表内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！