英文:
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.
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论