365 Functions are missing from my excel on MAC

Copper Contributor

hi, it is my first time purchasing Microsoft 365 subscription, and I have none of the functions included. I can only see them available when I use Microsoft excel on my iPhone and the website page thru office.com how can I get those functions available in mac desktop app on my mac? I already installed the apps thru the website and not from the app store. I need Unique functions, lambda, order, filter, and all that. 

 

Pd, I already checked for updates and it says all the apps are updated in all the channels, beta, current channel, and all that. help me, please. 

 

 

1 Reply

@Garciagrela I'm on exactly the same version/build, Beta Channel. This is what my Excel Help screen tells me about updates:

********

When do I get the newest features for Microsoft 365?

As new Microsoft 365 features become available, they are sometimes rolled out over a period of time to all subscribers. If you have a Microsoft 365 work or school account, the timing of when you receive new features may also depend on your organization’s settings. Eventually, all Microsoft 365 subscribers will receive the new features. If you don’t see a feature you’re expecting in your Office apps, there’s no need to worry—it’s on its way!

Note: New builds are also rolled out this way. This means when a build becomes available, not all customers will receive the new features right away. However, you can expect it to come to your device soon.

  • Who gets new features?
    All new features are included for free as part of your Microsoft 365 subscription. If you have a work or school account, your administrator may control when you see new features. If you have a one-time purchase of Office 2016 or 2019, you will receive security and performance updates but no new features.

  • How do I get new features?
    You will get them automatically as they are rolled out. You can also check for and install updates manually. (This does not guarantee that you will receive the newest features right away.)

  • When will new features arrive in my Office?
    We don't publish an exact day when the updates occur because that day can vary, and multiple updates could happen in a month. All Microsoft 365 subscribers will eventually get the new features. However, if you’d like to get them sooner, you can join the Office Insider program.

How are Office Updates rolled out?

If you've joined the Office Insider program, you get preview builds for the latest features, security updates, and performance fixes that Microsoft releases before anyone else. These channels determine how often, and how early, you get Office Insider updates. For Windows, Mac, and Android, there are two tracks: Beta Channel and Current Channel (Preview).

For Office Insider for iOS, there is only one track: Beta Channel.

When new features and updates are distributed, the timeline usually goes like this:

  1. Insiders who have signed up for Beta Channel on Windows, Mac, Android, or iOS, will receive the earliest, preview build first. This track is for Insiders who feel comfortable with using unsupported builds and will help identify issues and provide valuable feedback to Microsoft. 

  2. Next, Insiders who have joined Current Channel (Preview) on Windows, Mac, or Android, get access to preview builds. These preview builds differ, in that they are fully supported by Microsoft. This means there’s minimal risk and your feedback will be used to tweak and improve the final Office update.

  3. The remaining Microsoft 365 users get updates a little later, typically one to three weeks after Office Insiders, or possibly longer. When they’re released, these updates are sent to a small percentage of users first, and then more users are added over time until all Office subscribers are updated.

When new features are available, they will download automatically if you have Office for Windows. If automatic update is not turned on, you can Install Office updates manually. If you have a Mac, be sure to configure Mac to update automatically.

Ready to sign up? Visit the Join page to become an Office Insider. You can also follow the @OfficeInsider Twitter handle to find out about new features and updates that are released to Office Insiders.

*****