Excel 2010数据透视表损坏数据 [英] Excel 2010 Pivot Table corrupting data

问题描述

我有一个excel枢纽分析表，当刷新时会破坏数据.它基本上会丢失一个值，而用另一个值代替.

I have an excel pivot table that when refreshed is corrupting data. It basically loses the one value and replaces it with another.

因此，数据表在Prosperator列和"Rustenburg"列中的值为"Kramerville"，但数据透视表对其进行了更改，因此没有"Kramerville"，而是"Rustenburg"和"Rustenburg2".

So the datasheet has the value of "Kramerville" in the prosperator column and "Rustenburg" but the pivot table has changed it so there is no "Kramerville" but "Rustenburg" and "Rustenburg2".

有人知道为什么会这样吗?

Anyone know why it would behave like this?

谢谢

推荐答案

我没有找到发生这种情况的原因，但它似乎已损坏.对于任何有相同问题的人，我的建议是-将您的数据复制到新文件中，然后重新创建数据透视图，这对我来说是个好问题.我在新文件中使用了完全相同的VBA代码，并且效果很好，如果我发现了数据损坏的原因，我将进行更新，以便人们知道如何避免同一问题

I did not find why it had happened but it seems to have been a corrupted file. My suggestion for anyone having the same issue- copy your data into a new file and recreate the pivot, that cleared the issue for me. I used exactly the same VBA code in the new file and it works perfectly, If I discover why the data corrupted I will update so people know how to avoid the same issue

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