Jun 07 2019 10:16 AM
I am using Excel Pro Plus 2016, in Windows 10.
I have been using Excel with files in Excel and csv formats since the 1990s. I am very familiar with file type saving options and Excel's behavior in general. But just today I noticed something new and unexpected happening.
I open a csv file (called 'filename.csv') with a .csv extension. I work in that file a bit. I click the close button and am prompted with the grammatically sloppy phrase, "Want to save your changes to 'filename.csv'?" I click the SAVE button. Now, looking at the file's icon, it is still in the csv format and still has the .csv extension, as expected. However, when I open the file again, there have been significant format changes. All of the columns have been condensed into the first column.
So apparently, it has been saved in .xlsx format, even though the file type never changed from csv.
(Note that under Excel Options > Save > Save Workbooks the "Save files in this format:" option is set to .xlsx, because, frustratingly, there is no option to simply save files in their original format by default, as used to happen.)
The core of the issue is that the file has undergone conversion to xlsx without changing the filetype itself. Is this really supposed to happen?
Jun 07 2019 01:01 PM
Jun 07 2019 08:48 PM
Jun 08 2019 08:26 AM