excel 透视表 vba_使用Excel VBA删除数据透视表计算字段

excel 透视表 vba

Yesterday, I started out with the best of intentions, planning to get some work done, and find a couple of topics for upcoming blog posts. Then, while sipping my morning coffee and reading the RSS feeds, I clicked on an article about pivot tables.

昨天，我本着最好的意图开始了，计划做一些工作，并为即将到来的博客文章找到几个主题。 然后，一边喝着早晨咖啡并阅读RSS提要，一边单击了有关数据透视表的文章。

There were a few lines of sample code for creating a list of fields in the pivot table, which seemed like a good idea, but needed improvement. And there went the day!

有几行示例代码用于在数据透视表中创建字段列表，这似乎是个好主意，但需要改进。 一天过去了！

But, in the end, I had some useful code for removing calculated fields from the pivot table layout, so the day was productive, but not in the way that I anticipated.

但是，最后，我有一些有用的代码可用于从数据透视表布局中删除计算出的字段 ，因此这一天非常有成效，但并非我所预期的那样。

取向特性的奇怪结果 (Strange Results for Orientation Property)

The journey started out with that simple list of pivot table field names. I wanted to see more information about each field, so I wrote some Excel VBA code to list the pivot field caption, source name, location (orientation), position, sample data, and a formula (calculat