Office 365 filter function not working

[Fanta0575]

Just subscribed to office 365,filter f7nction working on my laptop and excel on my phone yet not working on other laptop, I have 5 devices which I can use the subscription on, why is the filter function working on some devices and not others!

 

[Yongle]

Is FILTER function not working or simply not available on the errant laptop
What is returned whenF ILTER formula is used
- #NAME? tells you the function is missing

Excel's File \ Account tab may provide a clue
- is it displaying Office 365 under Product Information?

In either case trying reinstalling OFFICE 365 on that laptop

 

[ISY]

Hi,

Subscribe to Excel 365 Insider and update

 

[MrExcel]

Just subscribed to office 365,filter f7nction working on my laptop and excel on my phone yet not working on other laptop, I have 5 devices which I can use the subscription on, why is the filter function working on some devices and not others!

Currently, as of 28 November, the Dynamic Arrays have been "flighted" to 20% of all Office 365 Monthly Channel accounts. The process of "flighting" is new at Microsoft and has personally been driving me crazy.

The thought process at Microsoft: "We are afraid this new feature will break something so we will send it out to 1% of all Office 365 accounts and see if there are a rash of negative feedback." 1% could be 5 million installs of Office. Last week, they flighted to a small percentage to see if any issues popped up. They did not. So, they increased to 20% of all Office 365 Monthly customers. This could be 100 million customers. That is why some of your devices have it and others do not. Both devices will have the exact same build. It is super maddening.

The Twitter account to watch for updates is Joe McDaid - he is a project manager on the Calc team.

https://twitter.com/x/status/1199441292989587456

 

[Yongle]

That is why some of your devices have it and others do not. Both devices will have the exact same build. It is super maddening.

WOW !

 

[Fanta0575]

WOW !

Currently, as of 28 November, the Dynamic Arrays have been "flighted" to 20% of all Office 365 Monthly Channel accounts. The process of "flighting" is new at Microsoft and has personally been driving me crazy.

The thought process at Microsoft: "We are afraid this new feature will break something so we will send it out to 1% of all Office 365 accounts and see if there are a rash of negative feedback." 1% could be 5 million installs of Office. Last week, they flighted to a small percentage to see if any issues popped up. They did not. So, they increased to 20% of all Office 365 Monthly customers. This could be 100 million customers. That is why some of your devices have it and others do not. Both devices will have the exact same build. It is super maddening.

The Twitter account to watch for updates is Joe McDaid - he is a project manager on the Calc team.

https://twitter.com/x/status/1199441292989587456

Thanks for the informative reply, hopefully they'll roll this out for all users asap, this function was one of the main reasons for me to subscribe to office 365 as it's not available on any other edition.
Goimg forward will they release this on future editions or just hold users to ransom for the subscription paid edition of excel!