Does anyone have a resource that gives possible reasons for this error message in Excel. I've googled around and looks like lots of people encounter the message but no one replies with concrete suggestions for resolving.
有没有人有一个资源，可以在Excel中提供此错误消息的可能原因。我已经google了一下，看起来很多人都会遇到这个消息，但是没有人回答具体的解决建议。
The actual source of data is an Excel list and is only 1000 rows long and a few users use this pivot table and refresh successfully only a couple encounter this error message when refreshing the exact same spreadsheet. They do not refresh at same time.
实际的数据源是一个Excel列表，只有1000行，一些用户使用此数据透视表并成功刷新，只有几个人在刷新完全相同的电子表格时遇到此错误消息。它们不会同时刷新。
2 个解决方案
#1
1
I hope this will resolve your issues as I've just encountered the same problem and was looking for a solution. I've discovered that the cause of this problem is that I've formulas encoded in some of the excel cells which I did the pivot. I simply copy all the data (about 58,000 rows of records,>100 columns of data, that's quite substantial) into another worksheet by pasting all data with 'Values'. Do a fresh pivot on this new worksheet and bravo! I don't have anymore of the errors which I encountered earlier. Mine you, I've lots of fields in this pivoted table and I don't get anymore errors. Check carefully if you've any formulas built-in your excel worksheet before you do the pivot. Hope the above helps.
我希望这会解决您的问题，因为我刚刚遇到同样的问题并且正在寻找解决方案。我发现这个问题的原因是我在一些excel单元格中编码的公式，我做了支点。我只是通过用“值”粘贴所有数据，将所有数据（大约58,000行记录，> 100列数据，这相当大）复制到另一个工作表中。在这个新的工作表和新的工作表上做一个新的支点！我不再有我之前遇到的错误。挖掘你，我在这个旋转表格中有很多字段，我不会再收到任何错误。在进行支点之前，请仔细检查您的Excel工作表中是否包含任何公式。希望以上有所帮助。
#2
1
For me the solution was to get rid of a Calculated item. I think they complicate the pivot and it doesn't work even if the amount of records doesn't seem like much.
对我来说，解决方案是摆脱计算项目。我认为它们使得枢轴变得复杂，即使记录数量看起来不那么多，它也不起作用。
#1
1
I hope this will resolve your issues as I've just encountered the same problem and was looking for a solution. I've discovered that the cause of this problem is that I've formulas encoded in some of the excel cells which I did the pivot. I simply copy all the data (about 58,000 rows of records,>100 columns of data, that's quite substantial) into another worksheet by pasting all data with 'Values'. Do a fresh pivot on this new worksheet and bravo! I don't have anymore of the errors which I encountered earlier. Mine you, I've lots of fields in this pivoted table and I don't get anymore errors. Check carefully if you've any formulas built-in your excel worksheet before you do the pivot. Hope the above helps.
我希望这会解决您的问题，因为我刚刚遇到同样的问题并且正在寻找解决方案。我发现这个问题的原因是我在一些excel单元格中编码的公式，我做了支点。我只是通过用“值”粘贴所有数据，将所有数据（大约58,000行记录，> 100列数据，这相当大）复制到另一个工作表中。在这个新的工作表和新的工作表上做一个新的支点！我不再有我之前遇到的错误。挖掘你，我在这个旋转表格中有很多字段，我不会再收到任何错误。在进行支点之前，请仔细检查您的Excel工作表中是否包含任何公式。希望以上有所帮助。
#2
1
For me the solution was to get rid of a Calculated item. I think they complicate the pivot and it doesn't work even if the amount of records doesn't seem like much.
对我来说，解决方案是摆脱计算项目。我认为它们使得枢轴变得复杂，即使记录数量看起来不那么多，它也不起作用。