.csv connection failure after a few hours. The "cannot refresh text..." error.

[Weered]

Hi Guys,

I have a workbook that collects data from 21 .csv files that records live forex data and consolidates it in 3 worksheets. It works great. Having said that, after operating for 5 hours or so it crashes with the "excel cannot find the text file to refresh this external data range" error. It doesn't tell me which one but it isn't relevant.

I have a feeling it has to do with save overlaps and the auto-update when the original data source is updating the 21 .csv files but I had hoped that there may be something simple I may have overlooked.

Thanks!