Power Query is holding into deleted data

Monsignor

Board Regular
Joined
May 30, 2011
Messages
158
I've got PQ set up to import data from a folder. I've noticed that if I remove one of the workbooks in the source folder and refresh my query, PQ is still holding the data from the removed workbook.How do I get PQ to recognize that the data's gone?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,247
Something is wrong. It can't be refreshing properly - this is not possible if it is refreshing properly. You should look at your query to see what is happening.
 

Monsignor

Board Regular
Joined
May 30, 2011
Messages
158
Something is wrong. It can't be refreshing properly - this is not possible if it is refreshing properly. You should look at your query to see what is happening.

Matt, thanks for the reply.

Upon further investigation, it turned out to not be a PQ problem. :p

It was a process problem that created duplicates, creating the illusion that the old data was still there.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

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
Top