Forum Discussion
Automatically start Excel & open csv file using _auto.csv
Hi Sergei ,
Thank you for the response, but no, I don't think you did understand.
1. If a file name contains the _auto.csv or .auto.csv as the filename suffix .... as an example
somefilename_auto.csv as opposed to somefilename.csv
2. On older versions (Excel even with W10) when such a file is downloaded onto the C: drive from an external source MS Excel automatically starts and opens the file in the first sheet. This also works for files like somefilename_auto.pdf (opens Acrobat and the file automatically).
3. With a new system with current versions of Windows 10 & Excel 265 this no longer happens.
When the file (somefilename_auto.csv) is downloaded Excel opens but with an empty window not even a blank sheet.
4. The file can then be opened manually. Alternatively once the file has downloaded and Excel closed double clicking on the file opens Excel and the file as expected, or if Excel is already open before downloading the file then the file opens in a new Excel sheet correctly.
5. So the question is why would Excel open automatically on the download of the file BUT NOT open the file itself as happens with older versions?
I hope this explains the issue better?
regards
Ivan
Ivan,
I see. Can say nothing about auto-opening, as for the empty window on opening such issue exists with Excel 2016.
Please check this https://support.microsoft.com/en-us/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a if something helps.