PDF Conversion Issues

Convert an Excel Form with Formulas and Macros into a Fillable PDF

Chanuka GeekiyanageChanuka Geekiyanage Nov 19, 2026 868 views

Question details

The user wants to convert an Excel form into a fillable PDF that calculates results from entered numbers.

Convert an Excel Form with Formulas and Macros into a Fillable PDF
Product
Microsoft Excel and Adobe Acrobat
Device & OS
not provided
Scenario
An Excel form contains formulas, unlocked input fields, macros, and password protection and needs to be distributed as a fillable PDF.
Observed behavior
The desired PDF should accept user input and calculate results while providing appropriate form security.
Before you start

Identify the Excel input cells, formulas, macro actions, and protection requirements before exporting the form. Check that your Acrobat edition and version support the form-authoring and JavaScript features you need.

Solution 1Recommended

Create PDF form fields and rebuild calculations in Acrobat

Use this approach to preserve the form layout and manually recreate calculations after exporting from Excel.

Exporting an Excel sheet to PDF does not automatically convert its formulas or VBA macros into Acrobat JavaScript. Excel cell protection and passwords also do not automatically become equivalent PDF form permissions.

1
Export the form layout

Open the workbook in Excel and use File > Save As or File > Export to create a PDF of the form. Check that the input areas and labels are visible in the exported file.

2
Create fillable fields

Open the PDF in Acrobat and choose All tools > Prepare a form. Let Acrobat detect fields if available, then add or adjust text fields using the form toolbar and give each field a meaningful name.

3
Recreate calculations

Open a result field's Properties, select the Calculate tab, and use a built-in calculation or a custom calculation script. For example, multiply fields named Quantity and Price with: event.value = (Number(this.getField('Quantity').value) || 0) * (Number(this.getField('Price').value) || 0);

4
Review macro behavior and security

Rebuild any required macro behavior using supported Acrobat form actions or JavaScript. Configure PDF security and permissions in Acrobat as needed; some Excel macro functions may have no direct PDF equivalent.

5
Test the completed form

Save the PDF, open it in the intended PDF reader, and enter sample values into the fields. Check calculations, field permissions, and any scripted actions; the reader must support and allow the JavaScript used.

Create PDF form fields and rebuild calculations in Acrobat
Check Acrobat feature availability: Form-authoring and advanced JavaScript capabilities vary by Acrobat edition and version. Confirm that your installation supports the features required before rebuilding the form.
Free Microsoft Office alternative

Prepare Excel Forms for PDF Export with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Microsoft Office files and exporting a form layout to PDF. Recreating interactive calculations and macro behavior still requires a capable PDF form editor.

Open and edit Excel-compatible spreadsheets before exporting their layouts to PDFWorks with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface helps make migration easierFree, lightweight tools for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Will Excel formulas automatically work in the exported PDF?

No. Exporting the worksheet preserves the visible layout, but formulas must be recreated in PDF form fields using Acrobat's Calculate options or custom JavaScript.

Can Acrobat convert Excel VBA macros into PDF JavaScript?

No. Review each macro and recreate the needed behavior with Acrobat form actions or JavaScript where possible. Some Excel-specific functions may not have a direct PDF equivalent.

How do I add a calculated total to a PDF form?

In Acrobat, open All tools > Prepare a form, create the input and result fields, and open the result field's Properties > Calculate tab. Choose a built-in calculation or enter a custom calculation script.

Does Excel sheet protection carry over to the PDF?

Excel sheet protection does not automatically become equivalent PDF security. Configure the PDF's security and form permissions separately in Acrobat, and test that intended users can fill in the fields.

Why might a calculated field not update for a recipient?

Check the field names and calculation settings in Acrobat, then test the form in the recipient's PDF reader. The reader must support and allow any JavaScript used by the calculation.