@Erik_Westwig, have you received any response from Microsoft? I raised concerns about the same thing about a year ago and am still not satisfied with the behavior in the current version. I am very worried that this will be released as-is and that spreadsheets created with our custom functions will suddenly show up as CSE array functions when they only return scalar values.
We use real-time data servers (RTD) for recalculation and there's a bug in older versions of Excel where the RTD server does not disconnect and will never refresh the data unless you restart Excel. I know this issue has been fixed in newer versions, however my worry is users opening the same files in older versions and running into all sorts of issues because everything is now marked as a CSE-array function...