Keep Excel Cell Values After Deleting Source Data
Question details
Preserve the current results of Excel formulas before deleting the data or workbook they reference.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Cells contain formulas linked to source data that the user plans to delete.
- Observed behavior
- The user wants the displayed results to remain as fixed values after the source is deleted.
Open the workbook containing the linked formulas and check that the cells show the results you want to keep. Update the links first if you need the latest source data.
Replace Linked Formulas with Values in Excel
Use Paste Special to keep the current results without relying on the source data.
In Excel, select the cells whose displayed results you want to preserve.
On the Home tab, select Copy, or right-click the selected cells and choose Copy.
With the same cells selected, choose Home > Paste > Paste Special > Values, then confirm if prompted.
Select a converted cell and check the formula bar: it should show a fixed value rather than a formula. You can then delete the source data or workbook.
Keep Spreadsheet Results as Values in WPS Office
Use Paste Special in WPS Spreadsheets to replace linked formulas with their current results before removing the source data.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and check that the linked cells show the results you want.
- 2. Select and copy the cells: Select the cells to preserve, then choose Home > Copy.
- 3. Paste the values: With the same cells selected, choose Home > Paste > Paste Special > Values and confirm if prompted.
- 4. Verify and save: Select a converted cell to check its value in the formula bar, then choose File > Save before deleting the source.

Frequently Asked Questions
Will pasted values update if the source data changes?
No. Paste Special > Values replaces formulas with their current results, so those cells will no longer update from the source.
Should I update links before converting formulas to values?
Yes, if you need the latest results. Update the workbook links and check the displayed values before using Home > Paste > Paste Special > Values.
Can I delete the source workbook after pasting values?
You can delete it after verifying that all cells you need have been converted. Any remaining formulas linked to that workbook may be affected.
Can I preserve results in an Excel file using WPS Spreadsheets?
Yes. Open the XLS or XLSX file in WPS Spreadsheets, copy the cells, and use Home > Paste > Paste Special > Values.




