Excel 4.0 funtion stored in defined names

320 Views Asked by At

I have a problem where excel is asking me to save my file as a xslm because it says I have Excel 4.0 stored in defined names, however, I do not have any names stored at all. Issue pop-up screenshot

My workbook is super simple, no macros, it only uses IFs and HLOOKUP formulas.

Also I explored other thread with a similar question, but the responses say to check for defined names and to disable the MySQL add or any other SQL connector, and I have neither of those (thread: Excel issue "excel 4.0 function stored in defined names").

No names defined screenshot.

No SQL add ins enables screenshot

I'm using Microsoft 365 with 2018 version.

Anyone knows what else could it be?

Thanks

:)

0

There are 0 best solutions below