I have two computers. My personal is an insider build 2006. If I am in a cell and type =A1#, if cell A1 has a dynamic array (Unique() for example) then my formula spills and returns the full array.
However, My work computer is on 1910 (I cannot upgrade past this - corp policy right now) which also has dynamic array functions, but typing =A1# returns a #REF! error if I am pointing to an a spilled array, in this case generated by UNIQUE() as well.
Is there some crazy option somewhere on this? I thought this was all rolled out simultaneously, not # references a few months later.