Power Query is holding into deleted data

Monsignor

Board Regular
Joined
May 30, 2011
Messages
162
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?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,308
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
162
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,424
Messages
5,837,155
Members
430,479
Latest member
mamush200

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