Document Editing Problems

Save an Excel Workbook as a New File Without Formulas or Macros

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Create a separate workbook containing formula results as values and no VBA macros, without changing the original workbook.

Save an Excel Workbook as a New File Without Formulas or Macros
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to save a new copy of an existing workbook, with cells such as B2 showing their calculated values instead of formulas.
Observed behavior
The new workbook should retain the displayed results without cell formulas or VBA macros, while the original retains its formulas.
Before you start

Open the original workbook and check that its formulas have calculated the results you want to keep. Identify every worksheet and cell range that contains formulas, since Paste Values must be applied to each relevant range.

Solution 1Recommended

Save a Macro-Free Copy and Paste Formula Results as Values

Use this method to create a separate workbook and replace formulas with their current results without editing the original.

1
Save a separate copy

In Excel, select File > Save As, choose a location, and enter a new file name. Choose Excel Workbook (.xlsx) as the file type and save it.

2
Confirm macro removal

If Excel warns that VBA features cannot be saved in a macro-free workbook, confirm that you want to continue. The new .xlsx file cannot retain VBA macros.

3
Replace formulas with values

In the new copy, select B2 or a range containing formulas and choose Home > Copy. With the same range selected, choose Home > Paste > Values. On Windows, you can use Alt+H, V, V after copying.

4
Repeat and save

Repeat Copy and Paste > Values for the relevant ranges on each worksheet, then select File > Save. Check a converted cell, such as B2, in the formula bar to confirm it contains a value rather than a formula.

5
Check the original

Open the original workbook separately and select B2 to confirm its formula remains in the formula bar.

Save a Macro-Free Copy and Paste Formula Results as Values
Scope of Paste Values: Paste Values replaces cell formulas only in the selected ranges. Check other workbook features, such as charts or defined names, separately if they must not contain formulas or links.
Work with spreadsheets in WPS Office

Create a Values-Only Workbook in WPS Spreadsheets

Use WPS Spreadsheets to save a separate .xlsx copy and replace selected formulas with their current values.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select the original workbook.
  2. 2. Save a new copy: Choose Menu > Save As, enter a new file name, and select the .xlsx format. Confirm any warning about unsupported macro features.
  3. 3. Paste results as values: In the new copy, select the formula cells, copy them, and use Paste Special > Values on the same range. Repeat for the relevant ranges on each worksheet.
  4. 4. Save and verify: Save the copy, then select a converted cell and check the formula bar. Open the original separately to verify its formulas are unchanged.
Replace spreadsheet formulas with their calculated valuesOpen and save Microsoft Excel .xlsx filesKeep the original workbook separate from the edited copyUse familiar spreadsheet editing controls
microsoft office alternative - wps office

Frequently Asked Questions

How do I replace the formula in B2 without changing its displayed result?

In the copied workbook, select B2, copy it, and choose Home > Paste > Values. The cell keeps its current calculated result instead of the formula.

Does saving as .xlsx remove formulas automatically?

No. The .xlsx format does not retain VBA macros, but cell formulas remain until you replace them, for example by using Paste > Values.

Will converting cells in the new copy change the original workbook?

No, provided you first use File > Save As with a different file name or location and make the changes in the new copy.

Do I need to paste values on every worksheet?

Yes. Copy and use Paste > Values on each range containing formulas that you want to remove. Converting one range does not convert formulas elsewhere.