Forum Discussion

Lucas_EV's avatar
Lucas_EV
Copper Contributor
Jul 11, 2022

Dynamic Arrays not enabled

Hey team, I was wondering if there was anything wrong with my Excel version since I am under the impreesion that newer functions such as UNIQUE and DA should be enabled but I haven't been able to use them. I'm using Ver 16.62 under a 365 subscription license on MacOS Monterrey. Please help? Thanks!

 

 

 

excel
Excel on Mac
office 365

2 Replies

  • JimGMac's avatar
    JimGMac
    MVP
    Jul 12, 2022
    The 16.63 update is now available. Please update then test again. Is your license from an IT department? If yes, they may be blocking new features. Check with them.
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 12, 2022

    Lucas_EV Just to be sure, what do you see when you check the version you are using? Excel, About Microsoft Excel.

    This is what I have (I'm on 16.64 though)

    But indeed, 16.62 should support the new DA functions. 

     

    Now, perhaps a silly thought. Before I subscribed (and installed) to Office365 for Mac, I had Excel for Mac 2011 running and didn't remove it. Then I forgot to set the default app for opening xlsx files to Excel under Office365. Hence, when I opened an Excel file by double-clicking on it, Excel 2011 fired up. Obviously, not what I wanted. Could this be what's happening to you?

Resources