如何更新Excel数据透视表筛选器?

huangapple go评论126阅读模式
英文:

How to update Excel Pivot filters?

问题

当我在数据透视表中更新信息后,我可以点击“刷新”,它会更新数据透视图中的数据。然而,似乎存在一个bug,它不会更新数据透视筛选器中的筛选值。

以下是一个简短的视频,展示了如何复现这个问题:https://gyazo.com/2a60fe4d01d171f94a284e7d3ead69e1。我该如何修复这个问题,还是我必须删除数据透视表中的筛选器然后重新添加(对我来说不是一个选项,因为我已经在模板中添加了筛选器!)。

英文:

When I have updated information in a Pivot table I can click "Refresh" and it will update the data within the pivot chart. However, there seems to be a bug where it does not update the filter values in the pivot filter.

如何更新Excel数据透视表筛选器?

Here is a brief video showing a way to reproduce this: https://gyazo.com/2a60fe4d01d171f94a284e7d3ead69e1. How do I fix this, or do I literally have to remove the filter in the pivot and re-add (that's not an option for me though since I have filters already added in a template!

答案1

得分: 1

根据我了解,通常情况下这是由于缓存内存而未更新,因此解决方法是右键单击“数据透视表选项” -> “数据”选项卡,然后将每个字段要保留的项目数更改为,现在如果刷新数据透视表,它肯定会正常工作。

英文:

As far I know generally it was not updating because of cache memory so the workaround is to right click on the Pivot Table Options --> Data Tab and change the number of items to retain per field to none, now if the pivot table is refreshed it will work certainly.


答案2

得分: -1

右键单击数据透视表,然后选择刷新。

英文:

Right-click the pivot table, and select Refresh.

huangapple
  • 本文由 发表于 2023年6月29日 01:50:03
  • 转载请务必保留本文链接:https://go.coder-hub.com/76575610.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定