Fix the List of Sheet Names Formula Error in WPS Office Spreadsheets
Question details
The user needs to resolve a formula error when generating a list of worksheet names in WPS Office Spreadsheets, where regional argument separators or a missing named range may be causing the INDEX/ROW formula to fail.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is trying to create a dynamic list of worksheet names using a named range and an INDEX/ROW formula in a spreadsheet.
- Observed behavior
- The formula returns an error instead of listing the sheet names, possibly because regional settings require semicolon argument separators instead of commas or because the named range SheetNames is missing.
Open the workbook where the formula is failing and confirm whether your spreadsheet application uses commas or semicolons as the list separator. Note the name used in the formula, such as SheetNames, so you can verify it in Name Manager.
Replace Function Argument Commas with Semicolons for Regional List Separators
Use this solution when your system decimal separator is a comma and the formula =INDEX(SheetNames,ROW()) returns an error.
Regional settings can change the separator used between function arguments. If commas are not accepted, replacing them with semicolons often resolves the error immediately.
Select the cell that contains the failing list of sheet names formula and click in the formula bar to edit it.
Replace the comma between function arguments with a semicolon, for example change =INDEX(SheetNames,ROW()) to =INDEX(SheetNames;ROW()).
Press Enter to confirm the corrected formula and check whether the worksheet name appears.
Verify and Recreate the SheetNames Named Range
Use this solution if the separator change does not fix the error or if the named range SheetNames is missing.
Fix the Sheet Names Formula Directly in WPS Office Spreadsheets
WPS Office Spreadsheets can correct the list of sheet names formula by adjusting the function argument separator to match your regional settings and by verifying the SheetNames named range. Make the change directly in the formula bar and use Name Manager to restore the worksheet name list.
- 1. Open your workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook containing the list of sheet names formula.
- 2. Edit the formula in the formula bar: Click the formula cell, then replace the function argument commas with semicolons if your regional settings require them, for example =INDEX(SheetNames;ROW()).
- 3. Open Name Manager: Go to the Formulas tab and click Name Manager to confirm that the named range SheetNames exists and points to the worksheet-name list.
- 4. Press Enter and recalculate: Press Enter to confirm the formula and click Calculate Now if needed to refresh the worksheet name list.
Frequently Asked Questions
Why does my INDEX/ROW sheet name formula work on one computer but not another?
Regional settings can change the function argument separator. If one computer uses a comma as the decimal separator, it may require semicolons instead of commas. Check the system list separator or replace commas with semicolons directly in the formula.
What should I do if changing commas to semicolons still returns an error?
Open the Formulas tab and click Name Manager. Verify that the named range SheetNames exists, is spelled exactly as used in the formula, and that its Refers To box points to the intended list of worksheet names.
Can I create a list of sheet names without using a named range in WPS Office?
Yes, you can type sheet names manually in a range. However, a dynamic list of sheet names usually requires a named range or a defined name that contains the worksheet names, which works with INDEX and ROW in WPS Office Spreadsheets.
Does WPS Office Spreadsheets support Excel INDEX and ROW formulas?
Yes, WPS Office Spreadsheets supports common Excel-compatible functions including INDEX and ROW, and it can open and edit .xlsx workbooks that contain these formulas.
How can I change the argument separator in WPS Office?
WPS Office follows the system regional settings. On Windows, you can change it in Control Panel under Region > Additional settings > List separator, or you can replace commas with semicolons directly in the formula.
