Forum Discussion
SEQUENCE function not working
I am using Excel with a 365 subscription and the version is 16.60. It is my understanding that the SEQUENCE function should work but when I open a file with that function it returns #NAME? Any assistance with troubleshooting would be greatly appreciated!
HansVogelaar and mtarler
I contacted Microsoft support and they went above and beyond to help me out.
It turned out that I needed to run First Aid and restart my computer. Excel is now able to run all dynamic array functions.
Thank you both for your help!
4 Replies
RAF314 There are a couple of things to check here. First I'm not sure what version 16.60 means go to File -> Account and you can find your version there:
It is possible you have multiple copies of Excel on your computer and even though you have Excel 365 you are running an old version or maybe it just isn't updating for some reason.
Also is it just SEQUENCE() or also FILTER() and UNIQUE() and the other functions added after dynamic arrays were added?
16.60 is the latest version for Mac: see Update history for Office for Mac
"April 12, 2022
Version 16.60 (22041000)"
Yes, thank you HansVogelaar this is on a Mac.
mtarlerI will look into whether there are multiple copies of excel. It is a new machine, so I do not think so. FILTER() & UNIQUE() also are not functional.
