Forum Discussion
Solved
New dynamic array functions not available in latest Excel version
I have Excel Version 1907 (Build 11901.20176) and according to the list of https://support.office.com/en-us/article/what-s-new-in-excel-for-office-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73 this vers...
With help from MS technical support I was able to solve this.
I wanted to use Excel’s dynamic array functions (e.g. Filter(), RandArray()).
I am an Office 365 Home Subscriber.
I was using version 1907 Build 11901.20176.
Per MS support suggestion, I joined Insider and subscribed to the insider newsletter.
It took about 10 minutes but eventually, new updates became available to Excel. (File->Account->Office Updates).
After downloading the updates, I closed and restarted Excel.
The functions are now available to me.