Formula using Named Range with EVALUATE function only triggered by in-cell calculation

Originally Posted by oeldere

You don't have any code in your posted file, so then there is no differance between xlsx and xlsm (as far as I know).

the use of XLM functions in defined names requires the use of a macro-enabled workbook format