Excel: Reenable warnings when saving a CSV file? - there is NO business bar and I have all the Trust Center Message Bar options checked

Question

Just lost 3 hrs of work b/c added macros to a .csv file that I did not know was a .csv file.

Programmed the macros. Saved it. Got no warnings. Opened it back up and, classic, all data was in col A and all the macros are gone.

July 2016 update took the csv incompatibility warning away.

Was supposed to be replaced with 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 – 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

Reality: There is no non-intrusive business bar.

Have all this checked:

https://support.office.com/en-us/article/Enable-or-disable-security-alerts-on-the-Message-Bar-adbf15d9-9195-4498-bdc3-5cb0dfe93852

Help? I need the warnings back!!! To loose 3 hrs is gut wrenching. MS didn't just throw out the baby with the bath water on this one, they threw out the whole bath tub. (This has happened to many people as you can see in the above posts)

At the very least (since MS is about as responsive as a dinosaur bone), does anyone have a workaround?

Moved from: Office /Excel / Windows 10 / Office 2016

Answer 1

PS - The only solution I have so far is to set  notepad as the default program to open csv files. It means an extra step to open it in excel, but at least I won't get trapped unawares!

A sucky solution, but at least a solution.