"The connection for this pivottable has been deleted" in Power Pivot

Mr_Stern

New Member
Joined
Feb 26, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top