Connect from excel 2016 to csv file

[Aviviis1968]

Hi
I am try to make data connection between excel
To csv file , but the csv file every date is change
For example now is temp-20042020.csv and day after
Is temp-21042020.csv , is it possible that
The data connection is update automaticaly .
I see that when i chose connection with string
There is no option to go to property string .

[#2]

Hi @Aviviis1968 

It is not possible for the data to update once there is a change in the file name. You will need to edit link so the connection can be re-establish.

To edit link, go to Data tab and choose edit link (in query & connection group, not sure this is the place in 2016 though). From the dialog box choose, change source and link to the new file.

If you use power query, you would have used Get data from data and any file in the folder will be uploaded and I believe this should also work when the filename changes. 

Cheers.