Hi,
Kind of an awkward one to explain.
I have a Power pivot that pulls data from an external table. - This works and refreshes as it should.
I then have a number of pivot tables using the multiple tables option (Add this data to the Data Model)
When I refresh these, all the pivots with the exception of one refresh.
The remaining one says 'The connection for this PivotTable has been deleted' if I try to refresh it individually.
Additionally if I try to create a new pivot table using the Data Model function I get the same error.
I also have other workbooks that I use the same power query and similar pivots etc. that all work fine.
Every week I refresh data and save down as a new version (e.g. week 19)
all prior versions work fine, but as soon as I refresh the data and save down its an issue.
Any thoughts on what the problem is or how to fix this?
Kind of an awkward one to explain.
I have a Power pivot that pulls data from an external table. - This works and refreshes as it should.
I then have a number of pivot tables using the multiple tables option (Add this data to the Data Model)
When I refresh these, all the pivots with the exception of one refresh.
The remaining one says 'The connection for this PivotTable has been deleted' if I try to refresh it individually.
Additionally if I try to create a new pivot table using the Data Model function I get the same error.
I also have other workbooks that I use the same power query and similar pivots etc. that all work fine.
Every week I refresh data and save down as a new version (e.g. week 19)
all prior versions work fine, but as soon as I refresh the data and save down its an issue.
Any thoughts on what the problem is or how to fix this?
