Excel Error Codes

Fix the #NAME? Error for the SEQUENCE Function in Excel

Muhammad TalhaMuhammad Talha Nov 18, 2026 870 views

Question details

The user needs to understand why Excel returns #NAME? for SEQUENCE and how to create a sequence in their version.

Fix the #NAME? Error for the SEQUENCE Function in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook uses the SEQUENCE function to generate a series of numbers.
Observed behavior
The SEQUENCE formula returns #NAME?, which may mean the installed Excel version does not recognize the function.
Before you start

Select the cell showing #NAME? and check the formula bar for a misspelled function name. Note which version of Excel you are using and whether you can update it.

Solution 1Recommended

Check and update your Excel version

Use a version of Excel that supports SEQUENCE, or update Microsoft 365 if the function is missing.

1
Check the version

In Excel for Windows, open File > Account and look under Product Information. On a Mac, choose Excel > About Excel.

2
Test a dynamic array formula

In a blank cell, enter =SEQUENCE(3). If Excel returns #NAME?, check the spelling; the installed version may not support the function. You can also check whether FILTER or XLOOKUP is available.

3
Update or switch versions

In Microsoft 365 for Windows, go to File > Account > Update Options > Update Now. On a Mac, choose Help > Check for Updates. If your edition does not support SEQUENCE, use a supported edition such as Microsoft 365, Excel 2021 or later, or Excel for the web.

4
Retest the workbook

Reopen the workbook in the updated or supported version and select the SEQUENCE formula cell to confirm that it produces the expected numbers.

Check and update your Excel version
Updates depend on your edition: Updating an older perpetual-license edition does not necessarily add newer functions. You may need a newer Excel edition or the helper formula below.
Free Microsoft Office alternative

Create Numbered Lists in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open an Excel workbook and use a helper formula and fill handle to create a numbered list without relying on SEQUENCE. Its Excel format support makes it easy to bring existing files into WPS.

Create numbered columns with a helper formula and fill handleOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What does #NAME? mean in a SEQUENCE formula?

It usually means Excel does not recognize something in the formula. Check the formula bar for a misspelling; if SEQUENCE is spelled correctly, your Excel version may not support it.

Which Excel versions support SEQUENCE?

SEQUENCE is available in Microsoft 365, Excel 2021 and later, and Excel for the web. Older Excel editions may return #NAME? because they do not include the function.

Can I create a sequence without upgrading Excel?

Yes. Enter =ROW(A1) in the first output cell, then drag its fill handle downward to create a numbered column.

Is #SPILL! the same as #NAME? for SEQUENCE?

No. #NAME? indicates that Excel does not recognize a name in the formula. #SPILL! means the formula's output cannot fill its intended range; check for cells or objects blocking that range.