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?
Microsoft Excel, the beloved productivity tool, is introducing some new features we think formula authors will love. Come learn the ins and outs of key new functions and calculation capabilities that will enable you to easily build solutions in the grid that were previously expert-only.
I'm not certain that a screenshot would be beneficial or necessary. Suffice it to say, since the latest 2/1/19 update of Office 365 Insider, many of my formulas have been incorrectly corrupted with the SINGLE function while being entered via my macros. In other words, if I input the formula manually, as such,
This usage of the SINGLE function completely corrupts my workbook, and, in fact, I receive a VBA error message that prevents updating of my worksheets.
In summary, the erroneous formula wrapping with the SINGLE function is most pervasive (in my experience) when the formula is created with a VBA macro, and that glitch appeared only after the latest update, since my worksheets have not otherwise changed in the interim.
If there were any way to disable auto-input of the SINGLE function, that would be fantastic. Would it be possible for you to pass this on to Joe McDaid?