Excel Version Compatibility Issues in VBA

[Larry Haydn]

I developed an Excel VBA application on my Windows 10 Office 365 platform.
My client is using Windows 8, Office 2016.
Additional info: their PC language is English, with Japanese as a secondary language.

My application crashed on their system.

Symptoms:
A formula =IFS(something|something|something...)
becomes =_xlfn.IFS(something,something,something...)

The pipe ( | ) changing to comma ( , ) probably means that their Excel is an older version.
But what is the _xlfn. that is inserted into the formula?

Anyone encounter this?
How did you solve this problem?

Other symptons:
I had copied some of the macros from their system to mine PC, and modified them.
Sometimes while editing these macros, my keyboard's double-quote ( " ) and AT ( @ ) keys gets swapped.
Why does this happen?
How to solve it?

 

[RoryA]

Yes, I did some testing with UDFs included and they were always all evaluated no matter where they appeared in the formula. Disappointing really.

 

[shg]

That's very curious.

Having nice animations is more important than efficiency.

 

[RoryA]

So it seems. The new spill functions are nice though (and some long overdue).