Warn users when they will lose formatting saving to CSV
I know a lot of people hated the warning when saving a workbook as CSV. Now that the warning has been removed, if you open a CSV file, make formatting changes and save the file - the formatting is lost with no warning at all.
Anders Harrison commented
Thank you Anonymous. I didn't realise I could turn the message back on. Problem mostly solved for me then. I just need to resist clicking that "Don't show again" button.
There's an option for a yellow warning bar. Excel Options > Save > Save Workbooks > Show data loss warning when editing comma delimited files. Unfortunately the yellow bar is very easy to dismiss and then never see again... Maybe should have been dismiss of this file rather than every csv? But still doesn't give a warning on save.
Adding a pivot table and save. Close and rename the file.... Heckkkkkkkkk only Pivot table sheet is available, remaining all sheets data is lost.
Kindly look into this serious issue.
Liam Wheldon commented
Just got caught out by this! Luckily only 10minutes work.. Deffo need this back in.. that fact it even says "saved" in the title is very very miss leading and incorrect..
just lost a days work and didn't know why until now............no profanity I an think of is enough!
Excel is dumbfuck commented
The formatting? Fuckign whole sheets get removed
Four hours of work lost.
MS Hater (as of now) commented
Microsoft- what the ? I just lost 4 hours because of this stunt. What the **** were you thinking?
Excel supports opening csv.
Excel supports making changes to csv.
Excel saves csv.
Excel closes csv.
Excel loses all changes without any hint.
See the problem?
Unbelievable...I've worked for many years in Excel, the warning was always there. Lost an hour this morning doing a really boring lot of work in a multi-sheet workbook. Opened as a csv, worked for an hour (completely forgetting it was a csv file I was working in, as Excel behaviour is exactly the same as for an xlsx file.) Saved it. Lost it all.....
Great work Microsoft. One wonders if you ever have any REAL people testing this stuff....oh yes, you sacked a lot of your testing team, didn't you....
I've just lost almost a days worth of tax workings. What the ****!
Adam Randall commented
Here is an idea.
If you cannot save extra tabs in csv files then maybe prevent the function when working in them. At the very least give people a warning they are about to lose all of their work. Cannot believe the warning got taken away.
Ignacio Ortiz commented
The solution given to COMPLETELY remove warnings is sub-optimal. Bring back the dialogs, or at least your yellow notification bar that tells: Btw, none of your formatting is truly being saved.
Dave Miner commented
I would just like an option that I could turn on that if I have made changes to a file that I opened as a CSV, it would default to just saving that file as an .xlsx.
That way if I just opened a CSV and changed some data, but didn't add tabs or pivot tables, it would default to saving as the original CSV.
If I've added tables and formatting and tabs, it would default to saving at the same locationas the .csv, just with the .xlsx format.
Same here, I tend to export files from database in csv format, but then play around with them, adding pivot tables, etc. When saving CTRL+S as a habit, it's saving everytime as CSV, and when I close and open the file again it's just useless... all the data lost since csv will only save the first tab, which is often where a dead pivot table sits...
Luckily I haven't lost any work due to this yet, but I accidentally chose not to be warned about saving as CSV / losing formatting. Can't believe there is no way to turn that back on.
Maybe a registry key we can update, at the very least?
I've lost new Excel users. When a user creates a pivot table in a new sheet from their csv file and exits while on the pivot table sheet, the source data sheet is lost!!!!! Only the pivot table is saved! This is a big no-no...hours and days of important work is lost if there is no backup. Excel appears dangerous and unstable. A new user has a terrible experience with Microsoft.
Yes - PLEASE add this back. Just lost another hour of work - VERY FRUSTRATING!!!
Gary Algier commented
Please fix the code to either prompt about a needed file format change at save time or open the file read-only. If someone really wants to edit the CSV and save the result back as a CSV, they could select the "allow editing" button. Blindly discarding work is NOT ok.
I agree with the need to have this feature brought back. I lost a mornings work recently because of this.