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
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