Re: Excel for good: Learning resources to help improve your Excel skills for the future

Copper Contributor

Good Day. I hope this is the correct platform
I have deleted a DATA table (Table 5) and now the PIVOT table is still looking for the DATA table when I refresh.

 

PietWalt_1-1589022402382.png

How do I rectify this?

1 Reply

@PietWalt The thing is that we have deleted the Table but still want to get the data by refreshing the Pivot Table. If you have deleted the Table you need to also delete the Pivot Table or change the data source.