Have to save twice for CSV file [closed]

Question

After I edit the existed CSV file, click save will prompt a message dialog "some feature in your workbook might be lost if you save it as CSV (Comma delimited)". Then I click "Save". After that when I click "Close" to close the CSV, prompt message dialog again "Want to save your changes to 'sample.csv' ". Why I have to save twice? How to solve it? Thanks

Answer 1

Why I have to save twice? That unfortunately is an inbuilt feature which AFAIK you cannot change.

Even I find that annoying. In your scenario if you click on No the 2nd time you get the popup, it will not create any problems because your file is already saved. Feel free to close that dialog box. There is no setting that you can change to avoid this behavior.

Btw, this behavior can be replicated in a normal workbook as well.

1. Create a new workbook. Type anything in Sheet1

2. Save it as a Csv. The first prompt that you will get is

   

3. The 2nd prompt that you will get it

   

4. Now close the file without making any changes. You will still get this prompt

   

This annoying feature cannot be turned off. You have to live with it. You can simply click on Don't Save or close the dialog box. Don't worry, your file is already saved as a CSV :)