How to Manage Hidden Excel Labs Functions and Formula Definitions in WPS Office
Question details
The user needs to restore access to hidden Excel Labs helper functions and formula definitions so they can edit or delete them after worksheets are copied.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user copied a worksheet that contains hidden helper functions created in Excel Labs or the Advanced Formula Environment and needs to update or remove those function definitions.
- Observed behavior
- Hidden functions do not appear in Name Manager, so copied worksheet definitions are difficult to edit or delete.
Before you start, open the workbook that contains the hidden functions and note the exact function names, especially any leading underscores. Keep Excel Labs or the Advanced Formula Environment available if you need to rename the hidden definitions.
Temporarily rename hidden functions to make them visible in Name Manager
Use this workaround when Excel Labs or Advanced Formula Environment helper functions are hidden and you cannot edit or delete them in Name Manager.
Hidden functions created by Excel Labs often use a leading underscore or are marked as hidden. Renaming them to a visible convention makes them available to the standard Name Manager in WPS Office Spreadsheets.
Open the workbook in Microsoft Excel, go to the Excel Labs add-in, and open the Advanced Formula Environment where the hidden functions are defined.
Locate each hidden function and rename it without the leading underscore, for example change _MyHelper to MyHelper.
Save the workbook so the renamed definitions are stored in the file.
Open WPS Office Spreadsheets, load the saved workbook, and click Formulas > Name Manager.
Select the function definition in Name Manager, then choose Edit or Delete and save the workbook again.

Keep reusable Excel Labs functions in a visible, separate module
Use this approach to avoid repeated hidden-name cleanup and make function maintenance easier.
Switch to WPS Office Spreadsheets for Easier Workbook Formula Management
Excel Labs is a Microsoft Excel add-in, and hidden Advanced Formula Environment functions can be difficult to manage. WPS Office Spreadsheets is a free, lightweight alternative that opens Excel workbooks, preserves formula definitions, and gives you a familiar Formulas > Name Manager interface for managing visible names without extra add-ins.
- 1. Download WPS Office: Download WPS Office Free from the official WPS website and install it on your device.
- 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx workbook that contains the formula definitions.
- 3. Review Name Manager: Click Formulas > Name Manager to review, edit, or delete visible defined names and functions.

Frequently Asked Questions
Why do hidden Excel Labs functions disappear from Name Manager?
Excel Labs or the Advanced Formula Environment can mark helper functions as hidden, often with a leading underscore or a hidden-name property. The standard Name Manager filters them out, so they cannot be edited or deleted until you rename them to visible names.
How do I edit a hidden LAMBDA function after copying a worksheet?
Temporarily remove the leading underscore in the Excel Labs Advanced Formula Environment, save the workbook, then open Formulas > Name Manager in WPS Office or Excel to edit or delete the definition.
Can WPS Office open Excel workbooks with LAMBDA functions?
WPS Office opens .xlsx workbooks and preserves defined names. If a function is hidden by Excel Labs, unhide it first; then WPS Spreadsheets can list the visible name in Formulas > Name Manager.
Do I need to repeat this workaround after copying worksheets?
Yes. Copied worksheets can carry hidden function definitions. After copying, check Name Manager again and repeat the rename-save-edit-save process if hidden names are present.
What is the easiest way to avoid hidden Excel Labs function problems?
Use visible function names without leading underscores and store reusable functions in a separate module or workbook so they are easier to manage in Name Manager.




