Forum Discussion

RAF314's avatar
RAF314
Copper Contributor
May 05, 2022
Solved

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 assis...
excel
Excel on Mac
Formulas and Functions
office 365
  • RAF314's avatar
    RAF314
    May 05, 2022

    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!

RAF314's avatar
RAF314
Copper Contributor
May 05, 2022

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.

  • RAF314's avatar
    RAF314
    Copper Contributor
    May 05, 2022

    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!

Resources