'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix the #NAME? Error with Excel's SEQUENCE Function
Question details
Users are encountering a #NAME? error when trying to use the SEQUENCE function to generate sequential numbers in an Excel spreadsheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Generating an array of sequential numbers in a formula using the SEQUENCE function.
- Observed behavior
- Excel fails to calculate the array and instead returns a #NAME? error in the formula cell.
Verify that you have typed the function name correctly, as a simple spelling mistake is one of the most common causes for the #NAME? error in any Excel formula.
Check Your Excel Version Compatibility
The SEQUENCE function is a modern dynamic array function and is not supported in older versions of Excel.
SEQUENCE is only available in Microsoft 365, Excel 2021, and newer versions. It is not supported in Excel 2019 or earlier. If you are using an older version, Excel will not recognize the function and will return a #NAME? error.
Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Account' from the left-hand menu.
Look under the 'Product Information' section. If your version is listed as Excel 2019, Excel 2016, or older, the SEQUENCE function is not supported on your software.
To use SEQUENCE, you will need to upgrade to a newer version of Microsoft Office or switch to a compatible alternative like WPS Office.
Correct Formula Syntax and Spelling
Misspelling the function name or using an incorrect regional translation will cause Excel to fail to recognize the formula.
Fix Invalid Nested Expressions
Incorrect expressions nested inside your SEQUENCE formula can trigger calculation errors.
Use WPS Office to Access Modern Spreadsheet Functions
If your current version of Microsoft Excel does not support dynamic array functions like SEQUENCE, WPS Office provides a free, lightweight, and highly capable alternative that handles modern formulas with ease.
Frequently Asked Questions
Why does Excel show #NAME? specifically for the SEQUENCE function?
This most commonly indicates that your version of Excel does not support dynamic array functions. The SEQUENCE function was introduced in Microsoft 365 and Excel 2021. If you use Excel 2019 or older, the program does not recognize the function name.
Can I enable the SEQUENCE function in Excel 2019?
No, the SEQUENCE function cannot be added or enabled in Excel 2019 or earlier versions. You must upgrade your software or use a free alternative suite like WPS Office that supports newer functions.
Does the #NAME? error mean my workbook is corrupt?
Not necessarily. The #NAME? error simply means the spreadsheet application does not recognize a text string in your formula. It is usually fixed by correcting a typo, updating your software, or fixing an invalid named range.
How do I check my Excel version to see if it supports SEQUENCE?
Open Excel, click on the 'File' tab, and select 'Account' (or 'Help' in older versions). Your version information will be listed under Product Information on the right side of the screen.
