Hi,

After reading various ideas etc on here i have setup several connections from a spreadsheet to different .csv files always stored in the same place on the I:/ drive - a usb stick.

first time i set up the spreadsheet the external links automatically updated upon pressing the refresh button.

since then however when i choose refresh Excel wants me to confirm the file for some reason (showing the explorer etc and i have to click the file). the trouble is as i have several files i dont know which one Excel is asking me for so i have a danger of pointing the wrong data to each link.

any ideas why these text files are not automatically updating as the files dont change name or move but do get updated?