Forum Discussion
Xlookup not available at all - Excel 365, version 2002, compilation 12527.20278
Xlookup not available at all - Excel 365, version 2002, compilation 12527.20278
Why?
It was available for a few weeks. Then whole program crashed. After reinstalling, there is no x.lookup?
Based on screenshot that's Office 365 Home or like, at least not ProPlus. For it you may switch from default (semi-annual or like) to insiders channel using second button menu, but it's grayed. I also can't understand what exactly the texts says, something about Windows 7. Most probably that's something about end of support of Windows 7 in Jan this year. With that you can't update the channel for Office365 if only you are not subscribed on paid Window 7 support which will continue another couple of years.
Above is my guess. What is for sure - build number doesn't matter, you have access to new functionality on channel basis. You may have exactly the same build on two different channels and you will have different functionality on these channels with it. Build number only means you have the code for this or that functionality within the build, but it is activated depends on which channel you are.
Thusd first you need to find a way how to activate the second button. Perhaps the link near it helps.
8 Replies
- The XLOOKUP is available in Office 365 Insiders and Monthly Channel. I believe you're on Monthly Channel having seen the function before .. Anyway, you can still verify the channel you're subscribed to... If on Monthly Channel, click on Updates.. It should be available
- Hello,
Open an Excel workbook > Click on File > Click on Account
You will be able to see aye channel of the Office 365 you're using. Kindly perform the steps above, screenshot and upload the image for me to see..
