Forum Discussion
Excel for Mac v.16.72 - dynamic arrays are not working.
I've tried removing all previous versions of Excel and reinstalling. But no luck. I got the family version with using dynamic arrays in mind.
It seems what worked was going deeper to remove files from previous MS Office install.