Calculation Issues

Keep Excel Cell Values After Deleting Source Data

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Replace Linked Formulas with Values in Excel

Use Paste Special to keep the current results without relying on the source data.

1
Select the linked cells

In Excel, select the cells whose displayed results you want to preserve.

2
Copy the selection

On the Home tab, select Copy, or right-click the selected cells and choose Copy.

3
Paste values in place

With the same cells selected, choose Home > Paste > Paste Special > Values, then confirm if prompted.

4
Check the results

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.

Values no longer update: Converted cells will not change when the source changes. Other formulas that still reference the deleted source may be affected.
WPS Office

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. 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and check that the linked cells show the results you want.
  2. 2. Select and copy the cells: Select the cells to preserve, then choose Home > Copy.
  3. 3. Paste the values: With the same cells selected, choose Home > Paste > Paste Special > Values and confirm if prompted.
  4. 4. Verify and save: Select a converted cell to check its value in the formula bar, then choose File > Save before deleting the source.
Keep displayed results without retaining their source linksOpen and edit Microsoft Excel XLS and XLSX filesWork with spreadsheets in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

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.