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

%3CLINGO-SUB%20id%3D%22lingo-sub-1376333%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376333%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day.%20I%20hope%20this%20is%20the%20correct%20platform%3CBR%20%2F%3EI%20have%20deleted%20a%20DATA%20table%20(Table%205)%20and%20now%20the%20PIVOT%20table%20is%20still%20looking%20for%20the%20DATA%20table%20when%20I%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PietWalt_1-1589022402382.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190363iD56C2670C5335153%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PietWalt_1-1589022402382.png%22%20alt%3D%22PietWalt_1-1589022402382.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20do%20I%20rectify%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385761%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661773%22%20target%3D%22_blank%22%3E%40PietWalt%3C%2FA%3E%26nbsp%3BThe%20thing%20is%20that%20we%20have%20deleted%20the%20Table%20but%20still%20want%20to%20get%20the%20data%20by%20refreshing%20the%20Pivot%20Table.%20If%20you%20have%20deleted%20the%20Table%20you%20need%20to%20also%20delete%20the%20Pivot%20Table%20or%20change%20the%20data%20source.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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