XLOOKUP, UNIQUE, FILTER, SORT Missing Excel 2023

[johnshep425]

I'm working at a new company, and my very first spreadsheets hit 32bit 2GB thresholds immediately

64bit excel was installed, and my spreadsheets lost XLOOKUP, UNIQUE, FILTER, and SORT functions

My IT Dept. isn't sure what went wrong, please help

Version 1808 (Build 10730.20304)

Semi-annual Channel

O365 MSO (16.10730.20304)

Desperately yours,

John

[#2 · Accepted solution]

The date on your version and build is March 2019. XLOOKUP, for example, was added on Semi-Annual with Version 2002 (12527.20442). Ask your IT dept to run 365 updates.

[#3]

I'm really glad it's just an update vs a new license. You're the best! Ty!

[#4]

You are welcome!