new excel glitch
1 TopicNew Excel glitch
Since this latest 2/1/2019 update, there is a new glitch with the Office Insider Dynamic Array functions. It seems that many, many more VBA-written formulas are now erroneously auto-inserting the SINGLE function, apparently due to the Excel Calc engine assuming a need for Implicit Intersection. This incorrect insertion of the SINGLE function is much more pervasive than it was as recently as the morning of 2/1/2019 (prior to the update) -- in the same workbooks, despite no interval change in the macros within those workbooks. Is there a way to disable auto-insertion of the SINGLE function, at least until this glitch is corrected with the next build?2KViews0likes3Comments