Remove Excel Formulas and VBA Before Sending a Report
Question details
Prepare an Excel report for external recipients without formulas, VBA, or external links.

- 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.
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.
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.
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.
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.
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.
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.
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 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. Open and copy the report: Open the Excel report in WPS Spreadsheets, select the range to share, and copy it.
- 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. 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. Export to PDF: Use Export to PDF, check the output, and share the PDF or the reviewed XLSX file.

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.




