Excel Interop - How to change PivotTable SourceData

I've got a similar problem as mentioned in the following question, however the accepted answer works only partially: How to update PivotTable data source using C#?

When I follow this answer, I see that my PivotTable gets updated correctly, but a second later Excel crashes and throws an 'RPC failed' error (HRESULT 0x800706BE The remote procedure call failed).

Am I missing something? Target app is Excel 365. EDIT: If it comes to used add-ins, SAP Analysis toolpak is used.