Remove Possible Data Loss Message from Microsoft Excel


Excel Warning Message:

Possible Data Loss: Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format.

Possible Data Loss CSV Excel Warning

You will see the above warning every time you try to work on a .csv (comma-separated values) file in Microsoft Excel (especially if you are using Microsoft Office for Mac)

How to Remove Possible Data Loss Message

On Windows:
  1. Go to File -> Options
  2. Now under Save -> Save Workbooks uncheck "Show data loss warning when editing comma delimited files(*.csv)"
  3. Click OK button.
On Mac:
  1. Click on Menu: Excel -> Preferences...
  2. Click on Save,
  3. Unckeck - "Show data loss warning when editing comma delimited files (*.csv)"
Mac Excel - Show data loss warning when editing comma delimited files csv

Now re-open the CSV file and you should not see this warning message!

If you wish to see the csv warning message again, just make sure to check the "Show Data Loss" checkbox again!

-


Have Questions? Post them here!

Topics Coverage:


🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.

Follow Us: GitHub | Facebook | Twitter | Instagram