Document Editing Problems

Remove Excel Formulas and VBA Before Sending a Report

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

Prepare an Excel report for external recipients without formulas, VBA, or external links.

Remove Excel Formulas and VBA Before Sending a Report
Product
Microsoft Excel
Device & OS
not provided
Scenario
A completed report needs to be shared as a workbook or PDF without exposing its calculations or macros.
Observed behavior
The recipient should receive report values in a macro-free workbook or a PDF rather than the original formulas and VBA project.
Before you start

Recalculate the report and confirm the displayed results are final before replacing formulas with values. Decide which worksheets and ranges recipients need, and check whether charts or other objects depend on external data.

Solution 1Recommended

Create a values-only, macro-free Excel report

Use a new workbook to share the report’s results without copying its formulas or VBA project.

1
Copy the report data

In Excel, select the report range on the completed worksheet and press Ctrl+C. Repeat the following paste steps for each range you need to share.

2
Paste values into a new workbook

Choose File > New > Blank workbook, select the destination cell, and use Home > Paste > Paste Special > Values. If needed, use Paste Special > Formats separately and adjust column widths.

3
Check for links and hidden content

Review the new workbook for any charts, names, or connections added separately. If Data > Edit Links or Workbook Links is available, inspect the listed links and break unwanted ones; also check for hidden sheets or data before sharing.

4
Save as XLSX

Choose File > Save As and select Excel Workbook (*.xlsx). If Excel warns that VBA cannot be saved in this format, confirm saving without it, then close and reopen the destination workbook to verify it.

5
Export a PDF if needed

Check File > Print to preview the report, then use File > Export or Save As and choose PDF. Review the PDF before sending it.

Create a values-only, macro-free Excel report
Using existing VBA: Your existing naming, folder, export, or email code can be adapted to create and save the destination report from the original macro-enabled workbook. The XLSX report itself cannot retain that VBA; test any automation before distributing the output.
Prepare a report in WPS

Create a Values-Only Report in WPS Spreadsheets

Use WPS Spreadsheets to paste report results into a new workbook, save a macro-free XLSX copy, and export a PDF for sharing.

  1. 1. Open and copy the report: Open the Excel report in WPS Spreadsheets, select the range to share, and copy it.
  2. 2. Paste values into a new workbook: Create a blank workbook, select the destination cell, and choose Paste Special > Values. Paste formats separately if needed.
  3. 3. Review and save the workbook: Check the new workbook for unwanted content or links, then use Save As to save it as an XLSX file, which cannot retain a VBA project.
  4. 4. Export to PDF: Use Export to PDF, check the output, and share the PDF or the reviewed XLSX file.
Replace report formulas with their displayed valuesOpen and save Microsoft Excel XLSX filesExport a report to PDF for distributionUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Does saving as XLSX remove formulas as well as macros?

No. XLSX cannot retain a VBA project, but it can contain formulas. Copy the report range and use Home > Paste > Paste Special > Values to replace formulas with their results.

How do I remove external links from the report?

In Excel, check Data > Edit Links or Workbook Links if the option is available, then review and break unwanted links. Also inspect charts, defined names, and data connections, since links can exist outside worksheet cells.

Can I keep my VBA code for naming and emailing the report?

Yes. Keep the automation in the original macro-enabled workbook and adapt it to create, save, or export the destination report. The shared XLSX file cannot retain the VBA project.

Is a PDF always safe to send externally?

A PDF avoids sharing the workbook’s formulas and VBA, but it can still expose sensitive report content. Check the PDF and its visible pages before sending it.