Dynamic Arrays not working on Mac

Copper Contributor

Hello!  I have a new Macbook Pro with MS 365.  I have downloaded Excel more than once and even re-purchased MS 365 through my company again to get a newer update.  I also then tried to download the free version from my university.  I cannot for the life of me get the dynamic arrays to work.  Specifically Sequence, rand array and frequency.  In fact I just had a midterm and got a problem wrong because it wasn't working.  Ideas?  I tried running first aid and rebooting, no dice.  

 

Help??

 

Thanks!

Veronica

4 Replies

@Nuklearv Similar to another post I responded to just minutes ago @Lucas_EV . Perhaps something else is going on. Can't really tell.

https://techcommunity.microsoft.com/t5/excel/dynamic-arrays-not-enabled/m-p/3570421 

 

 

@Nuklearv Check with your IT department. Some licenses do not allow new features to be active until 6 months or 1 year have passed after their introduction. Your install might be one of those.

 

Double check your version. The current update is 16.63. To see your version, use the Menu Bar and choose Excel > About Excel.

@JimGMac   I am still having this problem.  My IT depart is the government, so I can't really contact them.  I tried to download the 365 version the school offers, and they said they did not enable any type of limitations. In fact, if I use the school's web version it works fine.  

 

Still at a loss why this isn't working.  I'm running 16.64.  

Education licenses offer limited features. There are even different education licenses. I would not expect all features with an education license.