Save an Excel Workbook as a New File Without Formulas or Macros
Question details
Create a separate workbook containing formula results as values and no VBA macros, without changing the original workbook.

- 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.
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.
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.
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.
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.
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.
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.
Open the original workbook separately and select B2 to confirm its formula remains in the formula bar.

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. Open the workbook: Open WPS Spreadsheets and use Open to select the original workbook.
- 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. 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. 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.

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.




