数据透视表怎么刷新数据_数据模型的Excel数据透视表刷新错误

数据透视表怎么刷新数据

A simple data change can cause a strange pivot table refresh error, if you added the data to the Data Model. The problem is easy to fix, once you see what's causing it, but the error message, shown below, isn't much help! I'd never heard of function PCMinorObjectCollection, had you?

如果将数据添加到数据模型中，则简单的数据更改可能会导致奇怪的数据透视表刷新错误。 一旦发现问题的根源，就很容易解决该问题，但是下面显示的错误消息并没有多大帮助！ 我从未听说过函数PCMinorObjectCollection，对吗？

奇怪的错误信息 (Strange Error Message)

I learned about this problem from UniMord, who explained how to reproduce the error in a few simple steps. Hopefully, you'll never run into this problem, but thanks to UniMord for sharing his information, in case you need it!

我从UniMord了解了这个问题，他通过几个简单的步骤解释了如何重现该错误。 希望您永远不会遇到这个问题，但是感谢UniMord在需要时分享他的信息！

Here's an unreadable screen shot of the strange error – it's one of those really wide messages, and included references that I didn't recognize, such as function PCMinorObjectCollection. What is that?

这是一个奇怪的错误，它的屏幕截图不可读-这是真正的错误消息之一，其中包括我不认识的引用，例如函数PCMinorObjectCollection。 那是什么？

Here's an edited version of that message, with some of the text moved, so you can read all of it.

这是该消息的编辑版本，其中一些文本已移动，因此您可以阅读所有消息。

And here's a text version of the message, in case anyone is searching for help with this error message:

这是该消息的文本版本，以防有人在寻求有关此错误消息的帮助：

• We couldn't get data from the Data Model. Here's the error message we got:
  我们无法从数据模型中获取数据。 这是我们收到的错误消息：
• An unexpected error occurred (file 'pcminorobjcoll.inl', line 109, function PCMinorObjectCollection < class PCProperty, class NameHashSupport > ::SetNameAndUpdateCollection')
  发生意外错误(文件'pcminorobjcoll.inl'，行109，函数PCMinorObjectCollection <类PCProperty，类NameHashSupport> :: SetNameAndUpdateCollection')

是什么导致错误？ (What Caused the Error?)

Fortunately, UniMord didn't just send me a problem, and reproduction steps – he had figured o