Have to save twice for CSV file

excel excel-2007
Howard Hee picture Howard Hee · Dec 14, 2013 · Viewed 9.4k times · Source

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

Siddharth Rout picture Siddharth Rout · Dec 14, 2013

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

    enter image description here

  3. The 2nd prompt that you will get it

    enter image description here

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

    enter image description here

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 :)

Related questions

Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end. Example: [email protected] turns into [email protected], Data Sample: [email protected] satishmm_2sptc@…

Read More
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(…

Read More
Closing Excel Application using VBA

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False Which is the command that terminates the application? EDIT To say a little …

Read More