Pivot table added column in external source

[Packpack]

Hi all,

I have created a pivot table from external data source (xlsx table). Refresh with new records worked fine until I added one column to the external source. Now excel freezes when I refresh.

When I inserted one column in the internal data source the pivot table would only add a new data field when it is refreshed and everything would work fine.

Is there a way not to start with a PT from scratch when I add a new column to the external data source. I have many calculated fields in the PT and it looks just how I want.

Thank you,
Luka