Forum Discussion

johnshep425's avatar
johnshep425
Copper Contributor
Feb 27, 2023
Solved

XLOOKUP, UNIQUE, FILTER, SORT Missing Excel 2023

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

 

  • 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.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    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.

Resources