Jul 11 2022 01:07 PM
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!
Jul 11 2022 09:33 PM
@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?
Jul 12 2022 01:57 PM