Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?

I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file:

"[your spreadsheet] may contain features that are not compatible with CSV (Comma Delimited). Do you want to keep the workbook in this format?"

My answer is always going to be YES. Is there a registry setting to suppress this confirmation dialog?

Solution 1:

This is a common problem all Excel users suffer. I think, the only way to do that is to use a macro. For example:

Application.DisplayAlerts = False
With ThisWorkbook
    .SaveAs Left(.FullName, Len(.FullName) - 3) & "csv", xlCSV
End With
Application.DisplayAlerts = True

Solution 2:

I have Microsoft Office 365 ProPlus and today I noticed for the first time ever, Excel asking me if I want to disable CSV save notifications. I realize not everyone has Microsoft Office 365 ProPlus subscription but if you do, this might help. My version shows "Version 1609 (Build 7369.2118).

If you visit this link: Disable CSV Warning

It will show you where to find it. It's in:

File > Options > Save > Under 'Save workbooks' find checkbox that says "Show data loss warning when editing comma delimited files (*.csv)"

Solution 3:

I addressed it with ClickOff. The site it was hosted on is down, but I uploaded it here.