I face the problem with a pivot table and excel language version.
The issue is that I received a pivot table that was created in a different language version of excel. When I open this pivot table in my English version and want to refresh data the table gets corrupted and breaks down completely.
Did anyone experience the same and found a solution?