Incomprehensible Excel dialog

I'm saving a CSV file as CSV. Which option will lead to what happening? What does 'no' mean? Worse, if you do press no then the dialog comes back. Very perplexing.

  • Avery Smith 5y

    excel doesn't like csv even on windows. Unfortunately, this is what adobe needs to do data merges, so in the graphics design world you see this very often.
  • Jerry Knaus 5y

    Yup, this one's a classic.
  • shrtstck | 5y

    old warning is old.
  • orta therox 5y

    Another +1 on seeing it a million times
  • calzo 5y

    good spot boyo!
  • rsstn 5y

    nice job microsoft.
  • 5y

    How is that incomprehensible? Looks pretty straight forward to me. You made changes to the file that do not comply with the CSV format.
  • Rob Marquardt PRO 5y

    I like this one, where Office update can't continue until Microsoft AutoUpdate is quit:
  • Ken PRO 5y

    Try tabbing to buttons in the Office dialog boxes. It goes right to left. :-/
  • Jonathan Hoefler 5y

    At least on one side of the equator.
  • dakoepke 5y

    Excel 2007 packs a lot of fail into its "save as" feature. Open Excel, paste in CSV from somewhere, use the Text Import Wizard to convert it into a proper spreadsheet, and then immediately try to save it as a CSV.

    First, you get an OK/Cancel warning about how CSV doesn't support multiple worksheets (even though you haven't used any). That's followed by the pictured Yes/No dailog about feature incompatibility (even though you're saving data from a CSV as CSV). And, as icing on the cake, when you try to close the document, Excel asks if you want to save your changes (even though you didn't make any), and then gives you the pictured dialog again.
  • dpritchard 5y

    I agree, this one drives me crazy.

    I have conditioned myself to just clicking "Yes" to these dialogue boxes. Recently this got me into strife when the following came up (hint, you probably want to click "No" to this one):

  • eddypoon 5y

    I was stunned they ported this dialogue box from Excel on Windows. This really shows the quality behind ported software.
  • James 5y

    to answer your questions:

    "which option will lead to what happening?"
    if you click 'yes' the format will stay the same (csv) and the features in your work book that are incompatible will not be saved.

    if you click 'no' you have a chance to save these incompatible features by saving the file in the latest excel format.

    "what does 'no' mean?"
    'no' means you do not want to save the workbook as a csv

    how would you rewrite this dialog box?
  • Nathan Wright PRO 5y

    There are about 865 reasons that Office on the Mac is the worst software I've ever bought. Unfortunately the Canadian version is 249$ and worth about 1/10th of that as all I bloody need is Word template perfection.

    But God, saving, using Expose, anything - requires masses of patience/time that I don't have as Microsoft can't do a proper port and will not abide by OSX rules.

    Save as isn't shift + s, it's drop down menu, the same with unformatted paste - everything is slow. When these dialogues come up, it isn't even funny anymore - this software is simply the worst ever made, but sadly the only I can use for stupid, idiotic templates.
  • Mike Cohen 5y

    that's clear as mud.
  • AxsDeny PRO 5y

    @James at Uni: Yes and No are useless labels. The options should, at minimum, read:

    [ Save as XLS ] [ Save as CSV ]
  • Charles Arthur 5y

    @Appleton@rogers: it's CSV that I opened, without touching; nothing has changed. So why won't it let me save it to a different place also as a CSV?

    @James at Uni - yes, @AxsDeny has it right: the choices should be verbs, not yes/no. Verbs give you actions; yes/no doesn't tell you what the actual choices are.
  • Ken PRO 5y

    @ shigzeo: Keyboard Maestro is your friend. I just tried Shift+Cmd+S for Save As and it worked.
8 faves
Uploaded on May 19, 2010
  • Show EXIF

Additional info

  • Viewing this photo Public
  • Safety level of this photo Safe
  • S Search
    Photo navigation
    < > Thumbnail navigation
    Z Zoom
    B Back to context