frequent error when refreshing pivot table

Question

When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This happens every time. I have recreated the Pivot table in multiple ways and it still happens. I saw a discussion on this, but the issue was locked.

The original pivot table works fine. I save it out and when I return and refresh, I get this error situation.
I am using the latest version of Microsoft 365 Business Standard. I am running Excel locally when it happens.
What's up?

Answer 1

Kinda late, but this is how I solved a similar problem (I had the same error, refreshing on data model wasn't working either).

I noticed I had a previous pivot table based on a previous version of my query (I had modified/replaced some columns most likely). So I deleted that pivot table, and then it worked! I could update correctly my new pivot table, as simple as that.

Cheers

Answer 2

Hello, solved.

This is the URL https://www.pivot-table.com/2020/10/28/excel-data-model-pivot-table-refresh-error/