Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Probably not. Is a macro an option for you? – DaveParillo Nov 20 '09 at 22:41
There's an Excel AddIn (with source) for my related question How to Export -- not Save As -- to another format? that can help with this. – matt wilkie Oct 7 '15 at 16:03

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
share|improve this answer
would Left(.FullName, Len(.FullName) - 3) & "csv" mean in case of a foobar.xlsx a new filename foobar.csv, right? this omits the save dialog, and having custom names, right? in that case it is worth to note that if your workbook 'file' contains multiple worksheet 'tabs', then CSV can only can save the active one. and this would be better if addressed with the naming in my opinion, if possible! (unfortunately not a macro guy myself yet) – n611x007 Feb 13 '14 at 10:26
how does one add this macro...? – dwenaus Oct 7 '15 at 0:22

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.