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