If you click "Open", it will overwrite any file in the download folder with the same name. If you select "Save", it will create a new file name if the file already exists in your download folder. After the file is downloaded, you will be asked to indicate what you want to do, after which you can click "Open." These are two clicks instead of one ... but it works. Another option is to click the triangle of the drop-down list next to “Save” and then select “Save and open” ... but these are two more clicks. It is Excel that complains that it cannot open two files with the same name.
I don’t know why this changed ... maybe because someone decided that when you click "Open", you don’t care where the file is saved, so you don’t care if the file with the same name is overwritten, If it creates a new name every time you look at the file ... you can fill your download folder with temporary files that you do not need.
source share