Fix Defined Names Disappearing After Sharing an Excel File in WPS Office
Question details
The user needs to know why defined names or named ranges disappear after sharing an Excel file and how to verify, preserve, or restore them.
- Product
- WPS Office Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook with defined names referring to formulas or cell ranges is shared with another user or through a file transfer or export process.
- Observed behavior
- The shared workbook no longer shows the defined names or named ranges when opened.
Open the original workbook in WPS Office or Excel and confirm that the defined names still exist under Formulas > Name Manager before investigating the shared copy.
Check Defined Names in the Original and Shared Workbook
Use this first to confirm whether the names still exist in the source file and to identify when they were lost.
Defined names that refer to formulas or cell ranges should remain in a properly saved .xlsx workbook. If they are missing only from the shared copy, the issue is likely the sharing or export method, not the original file.
In WPS Office, open the original Excel workbook that contains the defined names.
Click the Formulas tab, then select Name Manager to list all defined names and their scope.
Open the shared file and repeat Formulas > Name Manager. If names are absent only in the shared copy, do not edit the original.
Share the Workbook in Its Original Excel Format
Use this method to avoid file conversions that can strip defined names.
Recreate Missing Defined Names in the Shared Workbook
Use this when the original file is not available or the shared copy is the only version.
Keep Defined Names Intact When Sharing Excel Files with WPS Office
Open, inspect, and share .xlsx workbooks in WPS Office so defined names and named ranges remain available. Use Name Manager to verify or recreate names after sharing.
- 1. Open the workbook: Start WPS Office Spreadsheets and open the original Excel workbook that contains the defined names.
- 2. Verify names: Click the Formulas tab > Name Manager and confirm the named ranges or defined names are present.
- 3. Share the original .xlsx file: Click File > Share or upload the original .xlsx to WPS Cloud, then send the link or attachment.
- 4. Check on the receiving device: Open the received file in WPS Office, go to Formulas > Name Manager, and confirm the names remain.
Frequently Asked Questions
Why do named ranges disappear after I share an Excel file?
They usually disappear because the file was saved or exported through a format that does not preserve Excel defined names, such as CSV, PDF, or certain import and export tools. Open Formulas > Name Manager in both the original and shared files to compare.
How do I check defined names in WPS Office?
Open the workbook, click the Formulas tab, and select Name Manager. It lists defined names, their formulas or cell ranges, and the worksheet scope.
What is the safest way to share an Excel file without losing named ranges?
Save the workbook as an Excel Workbook (*.xlsx) and share the original file by email attachment or WPS Cloud. Avoid exporting to CSV, PDF, or other non-Excel formats for editing.
Can I recover named ranges if the original file is gone?
Yes, you can recreate them. In the shared workbook, go to Formulas > Name Manager, click New, enter the same name, and set the formula or cell range, then save the file.
Does WPS Office support Excel defined names and formulas?
Yes, WPS Office Spreadsheets supports Excel defined names and formulas, and it can open and save .xlsx workbooks without removing them when the file is shared in its original format.
