Forum Discussion
Dynamic-aware Excel incorrectly flagging our custom XLL functions as being array functions?
Hello, we have the same problem that even functions that return only one string are considered to be potential array functions. This is true for XLL functions and for easy VBA functions ....
A simple function
Public Function SayHello () As String
SayHello = "Hello"
End Function
will be added in the new Excel version
= @ SayHello ()
and if you then enter the formula without @
= SayHello ()
will be in the old Excel version
{= SayHello ()}
...?
So if the functions can not return an array or object (Variant), then the behavior is not understandable in that though the UDF can only return a single object ....
- PeterBartholomew1May 27, 2019Silver Contributor
Could you clarify where the problems are occurring?
Are old workbooks failing to calculate in the DA versions of Excel or is it when you complete a round trip and try to get a modified workbook back into the production versions of Excel?
There are certainly occasions when I have seen '@'s sprinkled around like confetti but I think the workbook still calculates.