Excel: Reenable warnings when saving a CSV file? - there is NO - Microsoft Community

just lost 3 hrs of work b/c added macros .csv file did not know .csv file.

programmed macros. saved it. got no warnings. opened and, classic, data in col , macros gone.

july 2016 update took csv incompatibility warning away.

was supposed replaced this:

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10550424-no-more-warnings-about-saving-as-csv-especially-w

completed  ·  admindan battagin [ms xl] (admin, office.com) responded  ·  september 07, 2016

2016-09-07

we’re done – should no longer warning dialog data loss when saving file csv, long file opened csv file. instead, we’ve added non-intrusive business bar (that can ignore if choose) let’s save

reality: there no non-intrusive business bar.

have checked:

https://support.office.com/en-us/article/enable-or-disable-security-alerts-on-the-message-bar-adbf15d9-9195-4498-bdc3-5cb0dfe93852

help? need warnings back!!! loose 3 hrs gut wrenching. ms didn't throw out baby bath water on one, threw out whole bath tub. (this has happened many people can see in above posts)

at least (since ms responsive dinosaur bone), have workaround?

moved from: office / excel / windows 10 / office 2016

ps - solution have far set  notepad default program open csv files. means step open in excel, @ least won't trapped unawares!

a sucky solution, @ least solution.

Office / Excel / Microsoft Office Programming / Office 2016