Excel training

Hi Grace, thanks for the query. When you import data you have to browse to the file you want to import from, so you choose which file from the filename at that stage. If the CSV files are on an intranet site you could browse to the server folder if you are correctly networked, if not you have to download the CSV files to an offline folder and then import the one you want. Other than that, to import CSV files directly from an intranet site would require a bit of code running in the background to access the intranet site, connect to the correct file and then bring it into Excel, there is no standard tool to do this.

Hope this helps,

Anthony