No more warnings about saving as CSV, especially when I didn't change anything
I don't know how many hundreds (thousands?) of times I've told Excel that, yes, I really truly do mean to save this file as a CSV. I recognize that not all users will understand that CSV doesn't do cool formulas or formatting, etc., but I do and I still want to do it. And I want to do it a lot. Please, give me a way to opt out of these useless warnings!
We’re done – you should no longer get a warning dialog about data loss when saving a file as CSV, as long as the file was originally opened as a CSV file.
Instead, we’ve added a non-intrusive business bar (that you can ignore if you choose) that let’s you quickly Save As the file if you have made changes that are not savable in CSV; if you ignore it and just Save, we’ll just save out the CSV values as you’d expect.
We actually rolled this out starting on August 22, 2016 with build 15.25 for O365 users. Later builds have this update as well of course.
Thanks for participating in UserVoice – we definitely value your input. You can now use whatever votes you’d allocated for this idea for other ideas.
Is the non-intrusive business bar the large yellow bar that drops down every single time I save my document, and that I then must close? This is worse than the previous implementation IMO. The yellow bar is annoying and requires action every time. Is it possible to turn that off somehow?
Using Excel 2016, unchecking the option to "Show data loss warning when editing comma delimited files (".csv)" has absolutely no effect for me. It doesn't matter if I'm converting a file to CSV from Excel or opening an already existing CSV file on my computer. I get the warning about data loss every time--whether the "show data loss warning" is checked or unchecked. Would really like to disable this warning, as I have to save documents to CSV quite frequently.
Like this options too
This doesn't appear to have been corrected for Excel for Mac. I still see this all the time, regardless of whether or not the file was a csv when opened.
Paul Austin commented
I would like this option too. I use CSV and tabbed files lots for providing data to applications. On every change I want to save the dialog pops up.
A simple solution would be to have it show the first time and then include a tick box 'Don't show this warning again'.
Isaac Koch commented
This will never happen. It is part of the Microsoft marketing. They want you to use their file format.