Excel issue "excel 4.0 function stored in defined names"

Question

I am trying to isolate the issue causing

Excel 4.0 function stored in defined names.

Answer 1

Not to bump an old thread, but I had this same issue as well and wanted to post my resolution in case anyone else experiences the same thing as myself.

My problem ended up being caused by a MySQL Excel COM add-on that was a component included in the MySQL Workbench package. Disabling that add-on caused the macro prompt to disappear when saving spreadsheets.